Help changing text field to number field

[aamacher]

Hello,

I setup some Access fields as "text" but they were really numbers. So all of the numbers were entered as "text". When I paste them into Excel, it does not recognize them as numbers - even when I format the cells for numbers.

In Access, I changed the fields from "text" to "number" w/ 2 decimal places, however when converted I lose the decimal places!

Anyone know of a solution?

cheers,

Andy

 

[ddeldeb]

I gave it a try, and you need to change or put the tables format to Standard along with setting the decimal to 2 places.

 

[ChrisTolo]

You may also need to change the Number Type, in the Access table, from Long Integer to Double. That should maintain the decimal point.