We found out that the leading zeros in the wire name are exported in the csv file, however, Microsoft Excel treats it as numeric and displays it as a number. Please follow the steps below to show the leading zeros:
- Open Microsoft Excel, go to Data | From Text and browse the csv file. Click Next button in Step 1.
- In Step 2, ensure the Comma is checked for csv file or Tab is checked for tsv file. Click Next button:
- In Step 3, select the Wire column:
Ensure the Text is checked in the Column data format:
Click Finish button and select the area to insert the data:
After that, you should see the leading zeros in the wire name in Excel.
We found out that the leading zeros in the wire name are exported in the csv file, however, Microsoft Excel treats it as numeric and displays it as a number. Please follow the steps below to show the leading zeros:
1. Open Microsoft Excel, go to Data | From Text and browse the csv file. Click Next button in Step 1.
2. In Step 2, ensure the Comma is checked for csv file or Tab is checked for tsv file. Click Next button:
3. In Step 3, select the Wire column:
4. Ensure the Text is checked in the Column data format:
5. Click** Finish** button and select the area to insert the data:
After that, you should see the leading zeros in the wire name in Excel.
edited Jun 30 '20 at 9:08 am
