Shape Zip Code Notification For Free

Also called ?plus-four codes?, ?add-on codes?, or ?add-ons?, the ZIP+4 code starts with the standard five-digit ZIP Code. The four extra numbers are added after a hyphen to complete the ZIP+4. So what do the extra numbers mean? These last 4 digits represent specific delivery routes within delivery areas.

They are often used to show the boundaries of cities or buildings on maps. A postal code polygon database is a database of such geographical representations based on postal code data. They show the geographical limits of the postal codes within a territory.

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.

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

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.

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.

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

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.

Under the Number tab, select the Special category, and then select Zip Code. Click OK. Your zip codes will now appear with the correct leading zeros. Go to File | Save As and save your file as a standard Excel workbook.