Why do some ZIP codes only have 3 or 4 digits in Excel?
A. Several ZIP Codes start 0 or 00. Excel interprets the column as numeric data, and thusly removes all preceeding zeros. The data is good, it is simply Excel formatting the output. To correct this, open the spreadsheet. Select the column by clicking on A above the ZIP Code Label. At the top of the application, choose “Format” and then “Cells”. On the popup window, choose “Special” from the “Number Tab” section, and then choose “ZIP Code” to the right. Click “OK”. The ZIP Codes should now be formatted properly.
A. Several ZIP Codes start 0 or 00. Excel interprets the column as numeric data, therefore it removes all preceeding zeros. The data is good, it is simply Excel formatting the output. To correct this, open the spreadsheet. Highlight the column by clicking on “A” above the ZIP Code Label. From the menu at the top of the application, choose “Format” and then “Cells”. On the popup window, choose “Special” from the “Number Tab” section, and then choose “ZIP Code” to the right. Click “OK”. The ZIP Codes should now be formatted properly.
