Style Zip Code Resolution For Free

A 5-Digit ZIP code represents a USPS delivery area. 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.

The correct format for a numeric ZIP+4 code is five digits, a hyphen, and four digits. The first five digits represent the 5-digit ZIP Code; the sixth and seventh digits (the first two after the hyphen) identify an area known as a sector; the eighth and ninth digits identify a smaller area known as a segment.

The standard ZIP code notation used by the United States Postal service uses five digits to identify a delivery area. An example of a standard US ZIP code is 90210.

Apply a predefined postal code format to numbers Select the cell or range of cells that you want to format. On the Home tab, under Number, on the Number Format pop-up menu. , click Custom. In the Format Cells dialog box, under Category, click Special. In the Type list, click Zip Code or Zip Code + 4.

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.

Mailing addresses Note: ZIP is always all capital letters and code is lowercase. Use specific abbreviations for street suffixes (refer to the USPS comprehensive list of suffix abbreviations).

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).

The postal code is a six-character code defined and maintained by Canada Post Corporation (CPC) for the purpose of sorting and delivering mail. The characters are arranged in the form 'ANA NAN', where 'A' represents an alphabetic character and 'N' represents a numeric character ( e.g. , K1A 0T6).