Expand Zip Code Text For Free

A ZIP Code is a 5-digit number that specifies an individual destination post office or mail delivery area. ZIP Codes determine the destination of letters for final sorting and delivery. Each ZIP Code designates a collection of delivery routes used by mail carriers and areas serviced by the USPS.

Select the cell or range of cells that you want to format. , click the arrow, and then click More Number Formats. In the Format Cells dialog box, under Category, click Custom. In the Type box, type 0 followed by the postal code format that you want to use.

Include leading characters in postal codes 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, type 0 followed by the postal code format that you want to use.

ZIP codes, the postal code system used by the US Postal Service (USPS), were introduced in 1963. Their basic, and most familiar, format consists of five digits that indicate a specific delivery area.

Select the cell or range of cells that you want to format. Press Ctrl+1 to load the Format Cells dialog. Select the Number tab, then in the Category list, click Custom and then, in the Type box, type the number format, such as 000-00-0000 for a social security number code, or 00000 for a five-digit postal code.

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.

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.

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.

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.

The five-digit ZIP code plan was announced to the public on November 28, 1962 and implemented on July 1, 1963.