Add Leading Zeroes to the IDs in a Spreadsheet
To add the leading zeroes to the IDs in a column in an Excel spreadsheet, format the column as follows:
- Click on the column heading in the column that contains the IDs. Then right-click and choose “Format Cells”.
- Choose Custom, then enter seven zeroes (0000000) under Type. Click OK.
- Save your changes.