Three and Four Digit ZIP Codes Appearing in Database
Friday, May 18, 2012
Three and Four Digit ZIP CodesMany customers wonder why their data is including three and four digit ZIP codes. Of course, the United States Postal Service does not manufacture cities with only three and four digit ZIP codes. Most customers experience these because they are opening the data up with a program, such as Microsoft Excel, which has a default setting to eliminate zeros preceding a number. For instance, Holtsville, New York has a ZIP code of 00501. Excel will take that file, remove the zeros preceding the “5” and give you “501.”RemediesThere are three main ways to remedy this issue:
Either of these three ways are acceptable, however, we strongly recommend that you download the file type specific to the program that you will use.
- Instead of downloading the .CSV version of the file from ZipCodeDownload.com, download the “Excel (97 or later)” version. This has been preformatted to accept leading zeros.
- If you download the .CSV file, format the column by selecting the column and right clicking it selecting Format Cells> Number> Special> “Zip Code.”
- Follow the same steps in way number two but instead do …> Number> Custom> and under Type enter “00000”.