Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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 "Steve" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding Values With more than 2 decimal Places | Excel Discussion (Misc queries) | |||
decimal places within a formula | Excel Discussion (Misc queries) | |||
Changing default decimal places | Excel Discussion (Misc queries) | |||
goal seek wont calculate an accurate value past 3 decimal places | Excel Discussion (Misc queries) | |||
Entering numbers with variable decimal places. | Excel Worksheet Functions |