Word mail merge 2 decimal places

A mail merge with a twist!

To format a mail merge field to display two decimal places, you can use the following syntax:

& "0.00" (without quotes)

Here's an example:

Suppose you have a field called Amount in your data source, and you want to display it with two decimal places in your mail merge document.

In your mail merge document, you would use the following syntax:

The total amount is: & "0.00" Amount

When you run the mail merge, the Amount field will be replaced with the actual value, formatted to two decimal places.

For example, if the value of Amount is 123.456, the output would be:

The total amount is: 123.46

Note that the & symbol is used to indicate that the text is a mail merge field, and the 0.00 is the format specifier. The 0 represents a fixed digit, and the .00 represents the decimal places.