Cut Zip Code Contract For Free

Look Up a ZIP Code? By Address. Enter a corporate or residential street address, city, and state to see a specific ZIP Code?. Find by Address. By City and State. Enter city and state to see all the ZIP Codes? for that city. Find by City & State. Cities by ZIP Code? Enter a ZIP Code? to see the cities it covers.

Create a custom postal code format 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 Custom. In the Type list, select the number format that you want to customize.

The five-digit code which initially specified an area or a part of a town was no longer accurate or efficient enough. So, USPS created 9-digit ZIP Codes to ensure fast and accurate mailings.

If you want to improve the chances that the letter will make it to its destination quickly, you should use the five-digit ZIP code plus the four additional numbers that are specific to the area. To format, write the ZIP code with a hyphen afterward and then the four additional numbers will immediately follow that.

The extra 4 digits on ZIP Codes identify segments of fluid postal delivery routes. They're not permanent lines, so a 9 digits ZIP Code can change regularly. Five-digit ZIP Codes also change, but they do so infrequently; it's less likely that you will live in a ZIP Code when it changes.

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.

A 9-Digit ZIP code, also known as a ZIP+4 code or an extended ZIP code, includes the same information as the 5-Digit ZIP code, plus additional information about a specific delivery route within the delivery area.

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 USPS updates their zip codes quarterly.

ZIP Codes are numbered with the first digit representing a certain group of U.S. states, the second and third digits together representing a region in that group (or perhaps a large city) and the fourth and fifth digits representing a group of delivery addresses within that region.