FREE ZIP Code Finder
Enter ZIP Code:

*Find Info on any U.S. ZIP Code
Find ZIP+4 of Address

*Find the ZIP Code, county, and +4 of any U.S. Address
Other FREE Lookups
Area Code:

*Lookup ZIP Code of any city, state, county or area code
FREE Radius Search
Find all ZIP Codes

of ZIP Code:

» Download the FREE Radius Finder Application

FREE Distance Calc
Calculate the distance between two U.S. or Canadian ZIP codes.

Start ZIP:
End ZIP:

Why Are There 3 and 4 Digit ZIP Codes in the United States?

Questions? 1-800-425-1169

Aug 212012

Why Are There 3 and 4 Digit ZIP Codes in the United States?

When you open up our ZIP Code Database using MICROSOFT® EXCEL, you'll see 3 and 4 digit numbers in the ZIP Code column.  U.S. ZIP Codes are always five digits long. These 3 and 4 digit numbers actually begin with one or two zeros. For example, when you see "501" for Holtsville, it's really 00501.

As a default, Excel converts this column into a number and removes the leading zeros.  Luckily there's a quick and easy way to bring back what is missing.

1. The first thing you want to do is highlight the entire ZIP Code column. You can do this by clicking on the letter "A"  above the word "ZipCode". The column will turn a shade of light blue.


2. Use the right mouse button and click anywhere in the ZipCode column. Then click on "Format Cells".


3. Next, choose "Special" from the "Number" column, and make sure the "Type" is set to "Zip Code". Click on "OK" at the bottom when done.

That's all it takes! Now all those leading zeros have been added back in, making it a 5-digit ZIP Code.