csv drops decimal places

G

Guest

I convert excel to csv to load into another application (the application only
accepts csv files). It seems the save as csv process rounds or truncates
values to 9 decimal places. Is there a setting I can change that will give me
more decimals?
 
G

Guest

csv outputs to what the format is on the screen..

so if the value of the cell is

5.12345

but the cell is formatted
#0.00

it will only output to the csv
5.12


Change the number format on the worksheet
 

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

Top