Get Scaeop

0:09 3:41 How To Fix Broken Zip Codes in Excel & Word Mail Merge - YouTube YouTube Start of suggested clip End of suggested clip Under start mail merge choose step by step mail merge wizard. I'm going to be creating labels. SoMoreUnder start mail merge choose step by step mail merge wizard. I'm going to be creating labels. So then click Next. The starting document is basically the template that you're using in your printer.

Press [Alt] + F9 again. Position the cursor anywhere in this field and press the [F9] function key to update it. Or, right-click the field and choose Update Field. Preview the results to confirm the merge field displays with the formatting you want to see in the document for each of the mail merge records.

The field code will look something like {MERGEFIELD “fieldname” }. Directly after the end quote around the field name type \# followed by: 0 for rounded whole numbers. 0.00 if you want to round the number to two decimal places (or 0.000 if you want to round the number to three decimal places and so forth)

To extract the ZIP code, you will need to use a combination of the LEFT and RIGHT functions. To extract the ZIP code, follow these steps: Create a new column next to the address column. Enter the formula =RIGHT(cell,5) in the first cell of the new column, where "cell" is the cell containing the address.

Right-click the cell and select Format Cells... Then, go to the Number tab, select Special from the Category section and then select Zip Code from the Type section and hit OK.

Valid US ZIP Code Pattern US ZIP code (U.S. postal code) allows both the five-digit and nine-digit (called ZIP + 4) formats. E.g. a valid postal code should match 12345 and 12345-6789, but not 1234, 123456, 123456789, or 1234-56789.

Open the merge template document in Word and press Alt+F9 (for a PC) or Option+F9 (for a Mac) to reveal the merge field codes. Locate the number field for which you'd like to change the format. After the current merge field text, enter " \# " followed by the desired display format in quotation marks.