How to Re-Format Excel Columns to Allow Zip Codes with Leading Zeroes

To solve issues with leading zeroes in zip codes when opening a CSV file in Excel or inputting numbers starting with zero, follow the steps below.

User Types: Regulators, Sponsors & Employer Administrators


Restore Leading Zeroes in the Zip Code Field

Follow the steps below to restore missing leading zeroes in the zip code column of your report export. 

Step 1: Download the ApprentiScope report as a CSV file

Step 2: Open the report in Excel

  • Note: You can see that some zip codes in column G are missing a digit where the leading zero was removed. 


Step 3: Open the column menu & choose Number Format

  • Highlight the Zip Code Column
  • Right-click over the highlighted text
  • Select Number Format from the menu

  • Note:  The menu might say Format Cells instead of Number Format depending on your computer operating system or whether you're using the browser or desktop version of Excel.

Screenshot 2023-03-22 at 9.27.05 AM

Step 4: Choose Zip Code from the special format menu 

  • Click Special in the Category pane on the left side of the Number format box
  • Choose Zip Code in the Type box
  • Click OK

Step 5: View your restored leading zeroes


Format the Zip Code Column to Allow Leading Zeroes

If you've downloaded an ApprentiScope template, opened it in Excel, and cannot enter zip codes with leading zeroes without the zero disappearing, you should re-format the column by following the steps below. 

Step 1: Highlight the zip code column in the ApprentiScope template

Step 2: Right-click to open the column menu

Step 3: Choose Number format


Step 4: Select Special under Category

Step 5: Select Zip Code under Type

Step 6: Click OK

  • Note:  The menu might say Format Cells instead of Number Format

Screenshot 2023-03-22 at 9.27.05 AM

  • Now when you fill in your zip codes, you will not lose any leading zeroes.

 

Need further assistance? Submit a support ticket