Round Numbers in Word Mail Merge: A Step-by-Step Guide

To round numbers in a Word mail merge, add a numeric picture switch to the merge field, such as { MERGEFIELD Amount \# "#,##0.00" } for two decimal places and a thousands separator. Then preview the merge and check the finished document. This changes how the number is displayed; it does not alter the value stored in your data source.

Word usually does not carry over the number formatting you see in Excel, so a value displayed as currency or with two decimals in a spreadsheet may appear differently in a merged document. A field switch controls the Word output. If you need to round to a specific increment, such as the nearest five, round the value in your data source first.

What You’ll Need

A Word mail merge document and a connected recipient list, such as an Excel workbook or a database.
A numeric column containing the amounts, quantities, or other values you want to format. The source should contain real numbers, not text that only looks like numbers.
Microsoft Word for Microsoft 365 on Windows. The ribbon steps are similar on Mac, but some keyboard shortcuts differ.

Step-by-Step

Open the merge document and check the source field name. In Word, open the document containing your merge fields. If the recipient list is not connected yet, go to Mailings > Select Recipients and choose the list, or use Mailings > Edit Recipient List to check the records already attached. Make a note of the exact field name for the number, such as Amount, Price, or Balance. Field names with spaces must match the source column heading.
Find the number merge field. Turn on Mailings > Preview Results to see a sample recipient, then locate the number in the document. Alternatively, use Mailings > Insert Merge Field to see the available field names. The field may appear as «Amount» while results are being previewed, or as a field code when codes are displayed.
Display the field code. On Windows, press Alt+F9 to show or hide all field codes. To switch just the selected field, press Shift+F9. You should see something like { MERGEFIELD Amount }. On Mac, use Option+F9 to toggle field codes; depending on your keyboard settings, you may need to hold Fn as well. You can also use the Word menu or context menu options for showing field codes if the shortcut is assigned differently.
Add the number format switch. Click inside the field code after the field name and before its closing brace. Add a space, then type \# "#,##0.00". The complete field should read { MERGEFIELD Amount \# "#,##0.00" }, with your real source field name in place of Amount. The switch starts with a backslash and number sign; the format pattern goes inside straight quotation marks. Do not delete the field braces or add a second set around the switch.
Choose the pattern that matches the result you want. For two decimal places and grouping separators, use \# "#,##0.00". For a whole number with grouping separators, use \# "#,##0". For two decimal places without grouping, use \# "0.00". To display a currency symbol, for example dollars, use \# "$#,##0.00". Check the result for your regional settings: separators and currency conventions can vary by computer and document locale.
Hide codes and preview records. Press Alt+F9 on Windows or Option+F9 on Mac to return to the normal view. Select Mailings > Preview Results and move through several records using the arrow controls. For example, a source value of 1234.567 should display as 1,234.57 with the two-decimal pattern, while 1234 should display as 1,234. Look at small, large, negative, and blank values if they occur in your list.
Complete the merge and inspect the output. Choose Mailings > Finish & Merge > Edit Individual Documents to create a separate document containing the merged records. Review that output before printing or sending it. The merged document is the best place to confirm that every record has the intended separators, decimal places, and currency symbol. Save the result as a new file so you preserve the original merge template.
Use a source helper column for other rounding rules. A Word number format rounds the displayed number to the chosen number of decimal places; it does not round to arbitrary increments such as the nearest five, ten, or quarter. In Excel, with the source value in A2, a helper column formula =ROUND(A2,0) returns 1500 when A2 contains 1499.5. To round that same value to the nearest multiple of five, use =MROUND(A2,5); for example, if A2 is 1237, the result is 1235. Give the helper column a clear heading, save and close the workbook, then connect or refresh the merge list and insert that helper field in Word.

Common Mistakes

Typing braces instead of editing a field. Word field braces are special field characters. Typing ordinary { and } characters does not create a working merge field. Insert fields with Mailings > Insert Merge Field, or edit an existing field without removing its braces.
Using curly quotation marks. The number pattern should be enclosed in straight quotes, as in "0.00". Curly smart quotes can prevent Word from reading the picture switch correctly. If the switch does not take effect, replace the quotation marks directly in the field code.
Expecting the source cell format to control Word. Excel may show two decimal places while storing a more precise value. Word can use the underlying value and show a different number unless its merge field has an appropriate switch.
Confusing display rounding with data rounding. A field formatted with two decimals can show 12.35 for a value stored as 12.345, but the stored source value remains unchanged. If later calculations must use the rounded value, create a rounded helper value in the source rather than relying only on Word’s display.
Changing the wrong field or leaving a field name mismatch. Confirm the merge field corresponds to the intended numeric column. A switch on a date or text field will not format a number as expected.

Tips

Use the preview arrows to inspect multiple recipients, not just the first one. A blank cell, an unusually large amount, or a negative value can reveal problems that a typical record hides.
Keep your original merge template unchanged until you have checked the merged output. Save a separate final document, and retain the source workbook so you can correct values or headings if needed.
Make the display precision suit the information. Whole-dollar totals may be clearest without decimals; per-unit prices may need two or more. Do not hide meaningful precision just to make the page look tidier.
If you change the Excel helper column after connecting it to Word, save and close Excel before refreshing the recipient list in Word. If Word still shows old data, reconnect to the workbook or select the correct sheet or table again.
For repeated use, apply the switch in the merge template itself. You will not need to reformat every individual merged result each time you run the merge.

Troubleshooting

The result still shows too many decimals: Display the field code and check that the switch is inside the field braces, follows the field name, and uses a number sign, a space, and straight quotation marks. Verify the number of zeroes in the pattern: 0.00 specifies two decimal places. Hide the field codes and preview again.

The field code appears in the document instead of a number: Toggle field codes off with Alt+F9 on Windows or Option+F9 on Mac. If braces remain visible, confirm that you are looking at a real merge field rather than text typed into the document. Reinsert the field through Mailings > Insert Merge Field if necessary.

The merge shows Error! or leaves the number blank: Check that the source column contains numeric values and that the merge field name matches its heading. Text entries such as “$1,200” may not behave like numeric values if the currency symbol was typed into the cell. Clean or convert the source data, save it, and preview again. Also check whether the field switch was accidentally placed outside the closing brace.

Commas or decimal marks look wrong: Regional settings affect how number patterns are interpreted or displayed. Test a few records on the computer that will produce the final document. If the organization requires a particular convention, set the appropriate Word or system locale and verify the output rather than assuming another computer will display it identically.

The rounded result is mathematically wrong for the task: A picture switch controls decimal places, not a custom increment. For nearest-five or nearest-ten rounding, add a helper column in Excel with the appropriate rounding formula, then merge that calculated result. If a helper formula appears stale, confirm Excel has recalculated and saved the workbook before Word reads it again.

Frequently Asked Questions

Does Word round the original Excel value?
No. A numeric picture switch changes the value’s appearance in the merged document. The original cell remains as it was. Use a rounded source value or helper column if the rounded number must also be used in calculations.

How do I show no decimal places?
Use the number pattern #,##0 in the field switch, for example { MERGEFIELD Quantity \# "#,##0" }. The displayed value is rounded to a whole number, and thousands separators are included where appropriate.

Can I show two decimal places and a dollar sign?
Yes. Use a pattern such as $#,##0.00 inside the switch’s straight quotation marks. Confirm that the symbol and separators match the document’s intended currency and locale.

Can Word round to the nearest five cents or nearest ten?
Not with a standard decimal-place picture switch. Calculate the increment-rounded value in the data source, such as an Excel helper column, and merge that result. A decimal display pattern alone cannot express rounding to an arbitrary multiple.

Why does the merged document differ from the Excel worksheet?
Word may read the underlying numeric value rather than Excel’s cell display format. Add a numeric picture switch to the merge field, then check the finished output. Also confirm Word is connected to the intended workbook, sheet, and column.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.