2 decimal places in mail merge
In a mail merge, you can format numbers to display with 2 decimal places using a combination of the Format
function and the ROUND
function in Microsoft Word.
Here's an example:
- In your mail merge document, insert a merge field for the number you want to format (e.g.
@NumberVariable
). - Select the merge field and go to the "Home" tab in the ribbon.
- Click on the "Number" button in the "Number" group and select "Custom" from the dropdown menu.
- In the "Format" dialog box, click on the "Category" dropdown menu and select "Number".
- In the "Type" dropdown menu, select "Custom".
- In the "Format" field, enter the following formula:
=ROUND(@NumberVariable,2)
- Click "OK" to apply the format.
This will format the number to display with 2 decimal places. For example, if the value of @NumberVariable
is 12.3456, it will be displayed as 12.35.
Alternatively, you can also use the TEXT
function to format the number with 2 decimal places. Here's an example:
=TEXT(ROUND(@NumberVariable,2),"0.00")
This formula will also format the number to display with 2 decimal places.