Formatting Issues

How to Reverse Numbers and Format Currency in Word Mail Merge

Maira Mehtab Sep 28, 2026 869 views

Question details

The user needs to reverse the sign of numeric values and display them as dollar amounts within a Microsoft Word mail merge.

Product: Microsoft Word
Device & OS: not provided
Scenario: Formatting financial data during a mail merge so that positive values appear in parentheses and negative values appear as standard currency.
Observed behavior: By default, merged fields display raw numeric values without currency symbols or specialized positive/negative accounting formats.

Before you start

Ensure your Excel data source is correctly linked to your Word document and that the merge fields are already inserted into the page.

Solution 1Recommended

Use Field Codes to Apply Custom Currency Formatting

Toggle the field codes in your document to manually insert a numeric picture switch that defines how positive and negative currency values are displayed.

In Word, mail merge fields pull raw data rather than the formatted appearance from your spreadsheet. By adding a formatting switch to the field code, you can dictate exactly how the numbers appear, including reversing their signs and adding dollar symbols.

Reveal field codes

Click inside the merge field you want to format (e.g., Trust_Balance) and press Shift+F9 to display its underlying field code.

Add the numeric switch

Click inside the brackets, right after the field name, and type the following switch: \# "'-'$,0.00;$0.00".

Update the field

Press F9 (or Fn+F9 on some laptops) to update the field code and apply the formatting.

Hide field codes and merge

Press Shift+F9 again to return to the normal view. Proceed to run your mail merge to generate the final document with reversed and formatted currency values.

Understanding the Formatting Switch: The semicolon in the switch separates formats for positive and negative numbers. The first part "'-'$,0.00" formats positive numbers with a negative sign and dollar symbol, while the second part "$0.00" formats negative numbers as standard currency.

Efficient Document Processing

Perform Advanced Mail Merges with WPS Writer

WPS Office offers a robust and highly compatible Writer tool with comprehensive Mail Merge capabilities. You can effortlessly connect data sources, insert fields, and utilize advanced field codes to format currency, dates, and numbers exactly as needed.

1. Open your Document: Launch WPS Writer and open your mail merge template.
2. Connect Data Source: Navigate to the 'Mailings' tab, click 'Open Data Source', and select your spreadsheet.
3. Insert and Edit Fields: Click 'Insert Merge Field' to place your data. Right-click the field and select 'Toggle Field Codes' to add your formatting switches.
4. Merge to New Document: Click 'Merge to New Document' to generate your fully formatted letters or reports.

Fully compatible with Microsoft Word (.docx) formats and mail merge fieldsSeamlessly connects with Excel spreadsheets (.xlsx) for reliable data mergingSupports advanced field codes and numeric switches for custom data formattingLightweight, intuitive interface that is completely free to use

microsoft office alternative - wps office

Frequently Asked Questions

Why does my mail merge drop the currency symbol from Excel?

Word mail merge pulls the raw, unformatted data from your Excel spreadsheet. To display currency symbols in the merged document, you must add a numeric picture switch (like \# $,0.00) directly into the Word field code.

How do I format regular currency without reversing the sign?

To format standard currency, toggle the field code with Shift+F9, append \# "$,0.00" to the end of the merge field name, and press F9 to update.

What does the semicolon do in the mail merge number format?

The semicolon acts as a separator to define different formatting rules based on the value's sign. The section before the semicolon applies to positive numbers, and the section after applies to negative numbers.

Document & File Issues