Alter Zip Code Text For Free

You can format a cell or range of cells to display leading characters so that the postal code is preceded by enough characters to fill the cell's width. For example, you can use zeros or dashes to display a postal code as follows: 0000000 98052 or ------- 98052.

=LEFT (A2, 5) and press Enter on the keyboard. The function will return the first 5 characters from the cell. To copy the formula in all cells select cell B2, press the keysCTRL + C on the keyboard and select the range B3 to B6 and press key CTRL + V.

Over 1,000 ZIP codes have been decomissioned as post offices close or the needs of the United States Postal Service change.

The most common form of request to the Postal Service (and to Members of Congress) is for a new ZIP Code for a specific area. Most customers do not realize that a new, unique ZIP Code usually accompanies the creation of a new delivery post office.

United States ZIP codes are five numerical digits long. ZIP+4 codes, also known as add-on or plus-four codes, include four additional digits that identify a geographic segment within a ZIP code delivery area. The first digit in a ZIP code represents a defined group of U.S. states.

Any proposal for change must be submitted in writing to the district manager. The district manager is to work with the local postal managers, headquarters delivery, and headquarters Address Management System to evaluate the request and determine if an accommodation can be made.

Include leading characters in postal codesSelect 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.