Categorize Zip Code Text For Free

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.

Sorting ZIP CodesSelect the column (or cells) you want Excel to treat as text.Display the Home tab of the ribbon.Click the small icon at the lower-right corner of the Number group.Make sure the Number tab is selected.In the list of available formats, choose Text.Click on OK.Aug 5, 2021

Examples of private address unique ZIP Codes include the headquarters of Walmart (72716). An example of a PO Box-only ZIP Code is 22313, which is used for PO Boxes at the main post office in Alexandria, Virginia, such as those used by the United States Patent and Trademark Office.

Residential addressesYou will need to write the name of the state in which the city, town or village you are sending to is located.You will also need to add a five-digit ZIP code (postal code).Write the city/town/village name, the state and the ZIP code on the same line, as shown above.Nov 1, 2017

United States ZIP codes are five numerical digits long.The first digit in a ZIP code represents a defined group of U.S. states. The second and third digits represent a region in that group, such as a large city. To send mail, only the first five digits of the ZIP code are required.

Is the hyphen in a ZIP+4® ZIP Code2122 number required? Yes, when using a ZIP+4 ZIP Code, the number must consist of five digits, a hyphen (or dash), and four digits.

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 Special. In the Type list, click Zip Code or Zip Code + 4.