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.