Forum Discussion
Solved
Using/saving/re-opening CSV files in Excel - truncated digits
Hello, When editing a CSV file in Excel (note that the original data I receive from others is in Excel format, but has to be published in CSV format), I use the “format cells” in Excel and select ...
- When you save a file as CSV, you get what you see in the cells. If you want to show fewer decimal places, but retain the original digits, then you should save it as XLSX. Save a copy of the file as CSV for publishing.
When you save a file as CSV, you get what you see in the cells. If you want to show fewer decimal places, but retain the original digits, then you should save it as XLSX. Save a copy of the file as CSV for publishing.
Steve_SumProductComThanks for confirming what I suspected! The problem is I have to submit the data as CSV and the original data provider asked if the sheet could basically be "displayed" with only 2 digits (to look neat and standard), but maintain all the digits when you click on the cell. But now I have the support I need to say - nope, you can't have it both ways!