Leading zeros in CSV template

Excel tends to remove leading 0s in CSV templates. This can be an issue when adding Client IDs to the CSV template. The following steps will help you prevent this issue.
note
After you save and close the file, don’t reopen it. If you do, the formatting will revert and you will need to perform the following steps again before closing out of the program.
  1. Right-click a highlighted cell after selecting the entire column.
  2. Select
    Format
    .
  3. Go to the
    Number
    tab.
  4. Select the
    Custom
    category.
  5. Enter 0's in the
    Type
    section until the number is formatted correctly.
    note
    The number of 0s should equal the number of characters for that column; 5 digits for ZIP Codes.
  6. Select
    OK
    .
Once these steps are completed, save and close the file.