How to format numbers in word mail merge

In Microsoft Word, when performing a mail merge, you can format numbers in various ways to suit your needs. Here are some common methods:

Number formatting in the data source: Before merging, make sure the numbers in your data source (e.g., Excel spreadsheet or database) are formatted correctly. You can use the built-in number formatting options in your data source software to format numbers as desired (e.g., currency, percentage, date).
Using the Format field: In your Word document, insert a Format field to format numbers. The syntax is:
```
{=Format(number, "format")}
```
Replace number with the field name or a literal value, and format with the desired format (e.g., #,##0.00 for currency).

Example: {=Format(1234.56, "#,##0.00")} would display the number as $1,234.56.

Using the Number field: Another option is to use the Number field, which allows you to specify a format code. The syntax is:
```
{Number number;format}
```
Replace number with the field name or a literal value, and format with the desired format code (e.g., 0 for integer, 0.00 for decimal).

Example: {Number 1234.56;0.00} would display the number as 1234.56.

Using a custom format: You can also create a custom format using the Format field with a custom format code. For example:
```
{=Format(number, "Currency;[Red]$#,##0.00")}
```
This would display the number as a currency value with a red font color.
Using a merge field with a format: In some cases, you can use a merge field with a format code directly in your Word document. For example:
```
Dear [[First Name]], your order total is [[Order Total];#,##0.00].
```
This would display the order total with a comma as a thousand separator and two decimal places.

Remember to update your data source and re-run the mail merge to apply the formatting changes.