Organize Zip Code Transcript For Free

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

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 most complete ZIP Code is a nine-digit number consisting of five digits, a hyphen, and four digits, which the USPS describes by its trademark ZIP+4. The correct format for a numeric ZIP+4 code is five digits, a hyphen, and four digits.

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 ZIP number is a structured code in which the first digit identifies one of ten large areas of the Nation, and the second digit indicates a State, a geographic portion of a heavily populated State, or two or more less populated States.

5 Digit United States ZIP Codes is the range from 00501 to 99950. The full name of the country is United States of America (USA), commonly known as United States (US) or simply America.

When it comes to USA zip codes, they are always 5 digits long. However, sometimes these codes may also include leading zeros. If you store these zip codes as integers, any leading zeros would be stripped, resulting in missing data. As such, it's usually better to store zip codes as 5 character strings.

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.