If you’re having trouble importing AINs with leading 0s, use the following technique:
- 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.
Posted in: Importing Data