Switching to number from text

[ChristopherL]

Hi!


I'm having trouble swicthing the data type of my numbers.
When I am importing the table from another database it enters as a text.
When I then go to table design and try to switch it to number, it removes the decimals and switches the value to something ALOT higher.

Anyone know how to fix this so that it just enters as a number with the same value?

[Bob Fitz]

Try this:
After changing the data type property from text to number, change the "Field Size" property from "Long Integer" to "Single"

[ChristopherL]

Solved it, was beacuse of settings with "." and "," so it didnt recognize the decimal(Swede's use , while american values go with .)

Thanks!!