If you’re having trouble importing assets with leading 0s in their Asset Identification Numbers (AINs), Excel is likely removing the zeros before the import. To keep them, format the AIN column as Text or as a custom number format before importing. You can go with either of the following options:
Option 1: Format the AIN column as Text
- In Excel, right-click the AIN column → Format Cells → Text.
- Add a leading 0 to the relevant rows.
Option 2: Use a custom format and import a CSV
- Convert Excel to CSV using File → Save As → Format: CSV.
- Highlight the column with AINs → Right Click → Format Cells → Custom.
- In ‘Type’, enter the number of 0s you’d like to have for the AINs.
- Save, and import the CSV.
