| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
csv drops decimal places
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 | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
