Collate Zip Code Document For Free

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.

Right-click the field code that you want to edit, and then click Edit Field. In the Field dialog box, click Field Codes. In the Field codes box, make the changes that you want to the merge field.

Follow the steps below to 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.

To apply number formatting to an Excel mail merge field: Select the field, such as Amount, as shown in this example. Press Alt + F9 to reveal the field coding.Edit the field by simply inserting a numeric switch code to the end of the field.Press Alt + F9 again.

Apply a predefined postal code format to numbers Select the cell or range of cells that you want to format. On the Home tab, under Number, on the Number Format pop-up menu. , click Custom. In the Format Cells dialog box, under Category, click Special. In the Type list, click Zip Code or Zip Code + 4.

Apply a predefined postal code format to numbers Select the cell or range of cells that you want to format. On the Home tab, under Number, on the Number Format pop-up menu. , click Custom. In the Format Cells dialog box, under Category, click Special. In the Type list, click Zip Code or Zip Code + 4.

To format a merge field, complete the following steps: In the template document, while the merge field is selected, do the following to display the field code: Press Shift + F9 on Windows.Remove " \\ MERGEFORMAT " from the field code. Enter the switch in the field code. For example:Update the field: