Cut Zip Code Record For Free

The longest postcodes in the world belong to Iran (Islamic Rep.) and the United States of America. Postcodes in Iran consist of 10 digits below the locality name. In the United States of America, the ZIP+4 system defines postcodes as having five digits, a hyphen, and four digits.

This first-ever ZIP Code was 00601, designating a decent chunk of Puerto Rico as the first Zone Improvement Plan (ZIP) in the United States.

Steps Select the cell or range of cells that you want to format. Press Ctrl+1 to load the Format Cells dialog. Select the Number tab, then in the Category list, click Custom and then, in the Type box, type the number format, such as 000-00-0000 for a social security number code, or 00000 for a five-digit postal code.

The lowest ZIP Code number is 00501, unique for the Internal Revenue Service in Holtsville, NY.

The longest postcodes in the world belong to Iran (Islamic Rep.) and the United States of America. Postcodes in Iran consist of 10 digits below the locality name. In the United States of America, the ZIP+4 system defines postcodes as having five digits, a hyphen, and four digits.

Assuming we are talking about the US, the 00000 zip code does not exist. So why enter it in the database. Just send that postcard to "One Microsoft Way, Redmond, WA" without a zip code and it will get there just fine. Entering "magic values" like this may come to haunt you.

Displaying Zip/Postal Codes in Excel Right-click the cell and select Format Cells... Then, go to the Number tab, select Special from the Category section and then select Zip Code from the Type section and hit OK.

Field lengths : the longest postal code currently in use in the world is 10 digits long.

United States ZIP codes are five numerical digits long. ZIP+4 codes, also known as add-on or plus-four codes, include four additional digits that identify a geographic segment within a ZIP code delivery area.

Current Postal Code Range in the United States The current postal codes in the United States range from 00001 99950. The lowest and highest of these postal codes are both specific to areas in Alaska; The 00001 code is for the N Dillingham area, and the postal code 99950 is for Ketchikan, AK.