Design Zip Code Text For Free

A United States postal code, for example, might be either five digits or five digits followed a hyphen (dash) and another four digits (12345-1234). If you are validating US postal codes, allow for both conditions. The following rule validates a field that can be five digits, five digits + dash + 4 digits, or blank.

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.

Follow the steps below to 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.

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.

Due to an increase in population or to the improve postal operations, the US Postal Service® will occasionally add a new ZIP Code or change ZIP Code boundaries.

Create a custom postal code format Select the cell or range of cells that you want to format.On the Home tab, click the Dialog Box Launcher.In the Category box, click Custom. In the Type list, select the number format that you want to customize.In the Type box, make the necessary changes to the selected number format.

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.