decimal places in acces more than 2 places when importing an excel

[robertrobertrobertrobert]

I have saved a csv file in excel then imported it to access however when I
run a sum values query the value it brings back is ie. 120.965394000. which
is more than two decimal places.
I have changed the format in excel and the field propeties in access and the
poblem is still there. When I return to excel the and format numbers with 30
decimal places the values shown are ie 120.9700000000 etc. but when I sum up
the column it brings me back ie.587.0001. basically how can I only import
values with 2 decimal places in access from excel when the original data
maybe far more then 2 decimal places.

Please help me thanks.

Robert

 

[dlw]

What does the number in the CSV file look like? You probably need to
=round() before importing. Changing the format does nothing to the number,
it just changes how it is displayed.

 

[robertrobertrobertrobert]

Unfortunately their are not more 30 decimal places in excel when viewing a
CSV file and the numbers only appear as 120.000000000000000etc. I have opened
the CSV file in note pad and again there are only 1 to 2 decimal places.
however if I auto sum the column the value would be 5700.950000010000etc. by
highlighting row by row using the auto sum at the bottom of the screen I can
see when the decimal places are more than 2 however the value in question
still shows two decimal places.
The data is very large and I would like to round all values down to 2
decimal places easily before importing.

Thanks