Establish Zip Code Text For Free

Due to an increase in population or to the improve postal operations, the US Postal Service® will occasionally add a new ZIP Code or change ZIP Code boundaries.

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.

Can a Person Have Their Own ZIP Code? The answer is yes ? but only if you are the President of the United States or the First Lady. The POTUS's ZIP+4 code is 20500-0001, while the FLOTUS is 20500-0002.

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.

Fix numbers that should be text in Excel Click in a blank cell that is adjacent to the first number. As an example, see the image below. If E1 contains Zip and E2 to E9 have the actual zip codes, and your data stops in column G, you would click cell H2 and type =Text(E2,?00000?) and press Enter.

Display numbers as phone numbers Select the cell or range of cells that you want to format. How to select cells or ranges? On the Home tab, click the Dialog Box Launcher next to Number. In the Category box, click Special. In the Type list, click Phone Number.

To create a personal Zip, a postal customer would go to a postal web site, authenticate who they are, much as they do today to sign up for Informed Delivery, and provide their current address and, optionally, email address. The system would provide them their own 11 (or 12) digit Personal Zip Code.