dannyspencer
09-16-2005, 04:38 AM
Hi there,
I have imported in an excel table into access. It has a lot of numbers that have many digits after the decimal place. I want to cut this down since they are prices to just 2 decimal places.
Problem is that access imports the fields as Text fields. when i go to change the columns that i want as numbers it looses the information after the decimal place for example 1.1156834 when i click Number (long integer) and standard format it is converted to 1.00 loosing everything.
This is getting really really fustrating now.
When i import there is a drop down list but it is disabled where i can change the column property (number, text etc) so cant do anything about it.
any help would be great...
Dan
I have imported in an excel table into access. It has a lot of numbers that have many digits after the decimal place. I want to cut this down since they are prices to just 2 decimal places.
Problem is that access imports the fields as Text fields. when i go to change the columns that i want as numbers it looses the information after the decimal place for example 1.1156834 when i click Number (long integer) and standard format it is converted to 1.00 loosing everything.
This is getting really really fustrating now.
When i import there is a drop down list but it is disabled where i can change the column property (number, text etc) so cant do anything about it.
any help would be great...
Dan