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:
- In your mail merge document, place your cursor in the field where you want to display the value.
- Go to the "Insert" menu and select "Field" (or press
Alt + F9
). - In the "Field" dialog box, select "Merge Field" from the "Categories" list, and then select the field you want to format (e.g.,
TotalAmount
). - Click "OK" to insert the field.
- Right-click on the field and select "Toggle Field Codes" (or press
Alt + F9
again). - 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.
- Click "OK" to update the field code.
- 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:
- In the "Field" dialog box, select "Merge Field" from the "Categories" list, and then select the field you want to format (e.g.,
TotalAmount
). - Click "Number" in the "Format" section.
- In the "Number" dialog box, select "Custom" from the "Category" list.
- In the "Format" box, enter
0.00
and click "OK".
Either method should format your mail merge fields to display two decimal places.