Support Forums
When exporting an Electrical Connections Report leading zeros are removed from the wire name. I wish to use 4-digit wire names and use the exported file to create labels. Is this a bug or a setting?

When exporting an Electrical Connections Report leading zeros are removed from the wire name. I wish to use 4-digit wire names and use the exported file to create labels. Is this a bug or a setting?

When exporting an Electrical Connections Report leading zeros are removed from the wire name. I wish to use 4-digit wire names and use the exported file to create labels. Is this a bug or a setting?
edited Jun 30 at 3:58 am

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: 5efae01f2b550
  3. In Step 3, select the Wire column: 5efae03ebcd1e
  4. Ensure the Text is checked in the Column data format:
    5efae07153672

  5. Click Finish button and select the area to insert the data:

5efaf2f7ab038

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: ![5efae01f2b550](serve/attachment&path=5efae01f2b550) 3. In Step 3, select the Wire column: ![5efae03ebcd1e](serve/attachment&path=5efae03ebcd1e) 4. Ensure the Text is checked in the Column data format: ![5efae07153672](serve/attachment&path=5efae07153672) 5. Click** Finish** button and select the area to insert the data: ![5efaf2f7ab038](serve/attachment&path=5efaf2f7ab038) After that, you should see the leading zeros in the wire name in Excel.
edited Jun 30 at 9:08 am
24
1
2
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft