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!

​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!   Read More

​