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:

  1. In your mail merge document, insert a merge field for the number you want to format (e.g. @NumberVariable).
  2. Select the merge field and go to the "Home" tab in the ribbon.
  3. Click on the "Number" button in the "Number" group and select "Custom" from the dropdown menu.
  4. In the "Format" dialog box, click on the "Category" dropdown menu and select "Number".
  5. In the "Type" dropdown menu, select "Custom".
  6. In the "Format" field, enter the following formula: =ROUND(@NumberVariable,2)
  7. 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.