Others: How can I keep leading zeros in CSV files: Revision history

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

31 October 2022

  • curprev 13:1513:15, 31 October 2022‎ LaySwan talk contribs‎ 1,393 bytes +1,393‎ Created page with "'''Question:''' When I export a report to CSV file and open with Excel, all the leading zeros are cut off from nonzero numbers. How can I keep the leading zeros? '''Version:''' 1.8 / 1.9 / 2.0 File:Leading zero1.png File:Leading zero2.png <u><b>Answer:</b></u> The Excel automatically truncates all leading zeros from numbers in CSV files. However you may change the setting. <u><b>Excel:</b></u> 1) <span style='color:red'>Open a new worksheet</span> in E..."
Retrieved from "https://wiki.autocountsoft.com/wiki/Others:_How_can_I_keep_leading_zeros_in_CSV_files"