Import excel into Accees problem with too many decimal places

  • Thread starter robertrobertrobertrobert
  • Start date
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error exporting decimal values in csv file 0
Import from Excel - Access Adds Extra Decimal Places? 2
Decimal places in charts 4
Formatting decimal places 8
Data validation with decimal values in data source 3
Too many decimal places in Pie Chart 1
Sum of numbers with only two decimal places wrong 2
Zero problem with blank cell after automated data transfer 3

Top