Mail merge 2 decimal places with comma

A mail merge question!

To format a mail merge field to display two decimal places with a comma as the thousand separator, you can use the following syntax:

=TEXT(A1,"#,##0.00")

Assuming the field you want to format is in cell A1.

Here's a breakdown of the syntax:

• TEXT is the function that formats the value as text.
• A1 is the cell containing the value you want to format.
• #,##0.00 is the format string.
  • # is a placeholder for a digit (0-9).
  • , is the thousand separator.
  • ## is a placeholder for up to two digits.
  • 0.00 specifies that the value should be displayed with two decimal places.

When you use this syntax in a mail merge field, the resulting output will be a string with two decimal places and a comma as the thousand separator.

For example, if the value in cell A1 is 1234.5678, the formatted output would be 1,234.57.

Note that this syntax works in Microsoft Word and Excel, but the exact syntax may vary depending on the software you're using.