Mail merge to 2 decimal places

A mail merge question!

To format a mail merge field to display two decimal places, you can use the Format function in Microsoft Word. Here's how:

  1. In your mail merge document, place your cursor in the field where you want to display the value.
  2. Go to the "Insert" menu and select "Field" (or press Alt + F9).
  3. In the "Field" dialog box, select "Merge Field" from the "Categories" list, and then select the field you want to format (e.g., TotalAmount).
  4. Click "OK" to insert the field.
  5. Right-click on the field and select "Toggle Field Codes" (or press Alt + F9 again).
  6. In the field code, add the following format string: =Format([TotalAmount],"0.00")

The Format function takes two arguments: the value to format (in this case, the TotalAmount field), and the format string. The format string "0.00" specifies that you want to display the value with two decimal places.

  1. Click "OK" to update the field code.
  2. Repeat steps 2-7 for each field you want to format to two decimal places.

Alternatively, you can use the "Number" format option in the "Field" dialog box. To do this:

  1. In the "Field" dialog box, select "Merge Field" from the "Categories" list, and then select the field you want to format (e.g., TotalAmount).
  2. Click "Number" in the "Format" section.
  3. In the "Number" dialog box, select "Custom" from the "Category" list.
  4. In the "Format" box, enter 0.00 and click "OK".

Either method should format your mail merge fields to display two decimal places.