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.

How do I add a zero in front of a ZIP code in Excel?

Include leading characters in postal codes

  1. Select the cell or range of cells that you want to format.
  2. On the Home tab, click the Dialog Box Launcher.
  3. In the Category box, click Custom.
  4. In the Type list, type *0 followed by the postal code format that you want to use.

How do I keep font format in a mail merge?

Try each of the following steps in order until the issue is resolved:

  1. Open the merge document through the parameter file (not the finished product document).
  2. Highlight all the merge fields at once.
  3. Select Styles and Formatting from the Format menu.
  4. Select the ‘Normal’ formatting to each of the merge fields.

How do I combine two zip codes in Excel?

If you have the Zip code in cell A1 you can use the formula =TEXT(A1, “00000”) to format the Zip code as 5 digits wide with leading zeros and then merge that instead of the numeric version.

How do you format a 5 digit zip code in Excel?

Shorten to Five Digits

  1. Insert a new column to the right of your current zip code column.
  2. Type or copy and paste =LEFT(C2,5) , replacing C2 with your cell’s identifier.
  3. Drag the formula down the rest of your column.

How do I add a comma to a mail merge?

If you want commas in your number, use \##,### in your merge field. If you want dollars, rounded to two decimal places with commas, use \#$#,##0.00 in your merge field.

How do I stop an invalid merge field?

If the field is needed:

  1. Select the field on the Output tab of the export.
  2. Click Edit merge document.
  3. In the body of the merge document, delete the merge field.
  4. Re-insert the correct field: From the menu bar in the Word document, go to Tools> Insert Raiser’s Edge field. Re-select the field from the list.

What is mail merge format?

Mail merge is a useful tool to create a set of documents that are essentially the same but where each documents contain unique elements. However, when we merge some mails, we should pay more attention to the format of date, currency and number.

What is mail merge printing?

Mail merge printing is a great way to personalize your letters to increase response with direct mail. Mail merge data also known as variable data printing on digital printers can be printed in full color or black & white.

How do you format a ZIP code in Excel?

Re: format zip codes in Excel You can create a custom format by right-clicking the appropriate cell, then select >Format Cells and select the Number tab along the top. Select Custom from the list on the left. In the Type: box (which shows. the current format of the cell) type ##### or #####-#### if you want. zip+4 .