Expand Zip Code Bulletin For Free

A ZIP+4 code uses the basic five-digit code plus four additional digits to identify a geographic segment within the five-digit delivery area, such as a city block, a group of apartments, an individual high-volume receiver of mail, a post office box, or a specific delivery route ? meaning the actual path the mail truck

TLDR: A ? Zone Improvement Plan? or ZIP Code uses 5 numbers to point to a specific post office or area for mail delivery. Essentially ZIP Codes refer to a particular area serviced by the USPS.

Display numbers as postal codes, Social Security numbers, or phone numbers Select the cell or range of cells that you want to format. On the Home tab, next to General, in the Number Format box.In the Format Cells dialog box, under Category, click Special. In the Type list, click Zip Code or Zip Code + 4.

For example, you can use zeros or dashes to display a postal code as follows: 0000000 98052 or ------- 98052.

So, USPS created 9-digit ZIP Codes to ensure fast and accurate mailings. They indicate the actual path the mail should travel and usually they narrow down to somewhere between ten to twenty homes.

An extended ZIP+4 code was introduced in 1983 which includes the five digits of the ZIP code, followed by a hyphen and four additional digits that reference a more specific location.

So what do the extra numbers mean? These last 4 digits represent specific delivery routes within delivery areas. This extra detail means an even more precise matching to a more granular level. It could represent a handful of houses on one side of a street, or even a single building that receives a high volume of mail.

Shorten to Five Digits Insert a new column to the right of your current zip code column. Type or copy and paste =LEFT(C2,5) , replacing C2 with your cell's identifier. Drag the formula down the rest of your column.

The 9 is for anywhere on the West Coast and the Pacific, including Guam and American Samoa. 900 to 961 are all located in California, for example.

So what do the extra numbers mean? These last 4 digits represent specific delivery routes within delivery areas. This extra detail means an even more precise matching to a more granular level. It could represent a handful of houses on one side of a street, or even a single building that receives a high volume of mail.