Adjust Zip Code Paper For Free

If you receive this error: Double-check you entered the correct two-letter state code. Make sure you've entered the ZIP code in either 5-digit or 9-digit format (for example 12345 or 12345-6789). Look up the correct ZIP code for the street address in question.

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.

If you want to improve the chances that the letter will make it to its destination quickly, you should use the five-digit ZIP code plus the four additional numbers that are specific to the area. To format, write the ZIP code with a hyphen afterward and then the four additional numbers will immediately follow that.

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.

Because ZIP Codes are the cornerstone of the U.S. Postal Service's (USPS's) mail distribution system, USPS has long resisted changing them for any reason other than to improve the efficiency of delivery. Frustrated citizens frequently have turned to members of Congress for assistance in altering ZIP Code boundaries.

At this point you have the first five digits of the ZIP Code in the original column and the last four digits (if any) in the previously empty column to the right. You can delete the column containing the four digits, if desired. All you need to do is select the cells containing the ZIP Codes, and then run the macro.

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