Others: How can I keep leading zeros in CSV files

From AutoCount Resource Center

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

Leading zero1.png


Leading zero2.png


Answer:

The Excel automatically truncates all leading zeros from numbers in CSV files. However you may change the setting.


Excel:

1) Open a new worksheet in Excel.

** Do not open the CSV file exported directly with Excel.


2) Select the Data tab and click on the From Text/CSV button.

Leading zero3.png


3) Select Do Not Detect data types and click on the Load button.

Leading zero4.png


4) The leading zeros is shown now.

Leading zero5.png


5) You may also click on Table Design and uncheck Header Rows and Banded Rows. So that these rows will not be shown.

Leading zero6.png

Leading zero7.png


6) Then go to File > Save As to save in Excel file type.


By: Jodie 221011, Lay Swan 221026, P221031


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations