Start a new topic

Leading zeros dropped from Zip Codes in Excel

Q:  I am working on an import file in Excel.  Unfortunately, the zeros at the beginning of my zip code have been dropped.  How can I correct this? 

 

A:  When you load a CSV file into Excel, it tries to determine the format of the data being accessed. Excel automatically recognizes the zip code as a number and, by default, removes the zero from the front of the number.  To resolve the issue, you will need to do the following:

  1. Rename the .CSV file so that it has a .TXT extension. 
  2. In Excel, go to File, Open and browse for the newly renamed file.  Click Open to access the file.
  3. Excel will launch the Text Import Wizard.
  4. Select Delimited as the data type and click on Next. 
  5. Select Comma as the delimiter.  Your file will show in the newly parsed format at the bottom of the window.  Click on Next. 
  6. In the Data Preview section at the bottom of the window, highlight the Zip Code column. 
  7. In the Column Data Format area, click the Text radio button.
  8. Repeat steps 6 and 7 for other fields that have leading zeros.
  9. Click on Finish. Your file is imported with leading zeros intact.

When you have completed your work, select File, Save As to save the file in .CSV format for importing.  

Login or Signup to post a comment