Due to the way Microsoft Excel handles values, any PIN code or card number starting with 0 will not display that leading zero by default. For example, a PIN code of 0123 will display in Excel as 123. Since it displays as a three-digit PIN code, you will receive an error message for the user stating their PIN code is too short. To get around this you will be required to adjust the spreadsheet to display the leading zeros.
To adjust a spreadsheet to display leading zeros:
- Open Microsoft Excel.
- Select the user's PIN code or the PIN code column if there are multiple instances.
- Right-click the selected cell or PIN code column header, then click Format Cells.
- Click Number.
- In Category, click Custom.
- In the Type field, enter the number of 0s necessary to accommodate the largest value. For instance, a minimum PIN code length is four digits, so it is required to enter four 0s.
- Click OK.