Forum Discussion
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 number of decimal places, save file, then re-open the file – the original digits are actually truncated instead of just hidden. I want to keep all the digits, but just have the viewer/user see 2 (or 4, or whatever) decimal places (however, they should see all the digits when they click on the cell).
Does anyone know how to preserve all the original digits, but only have the viewer/user see 2 (or 4, etc...) digits for neatness/uniformity sake?
Example attached.
Thanks!
- 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_SumProductComIron ContributorWhen 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.
- ReneeBay5000Copper Contributor
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!