How to Display Negative Mail Merge Amounts With a Minus Sign
Question details
The user needs to display negative currency or number values with a minus sign rather than enclosed in parentheses when executing a mail merge.

- Product
- Word
- Device & OS
- Windows
- Scenario
- Formatting currency and number fields during a document mail merge.
- Observed behavior
- Mail merge outputs negative amounts wrapped in parentheses instead of using a standard minus sign.
Ensure your mail merge main document is connected to the data source and that you are familiar with toggling field codes using the Alt+F9 keyboard shortcut.
Use a Numeric Picture Switch in the Merge Field
Modify the MERGEFIELD code manually to enforce specific formatting for positive and negative numbers.
By default, mail merge pulls raw data from your source file, which can sometimes result in unexpected formatting. Adding a numeric picture switch (\#) directly to the field code allows you to define exactly how positive and negative numbers should appear.
Press Alt+F9 on your keyboard to reveal the underlying field codes in your document. Your merge field should look something like { MERGEFIELD Your_Amount_Field }.
Click inside the closing bracket of the field code and type your formatting switch. To separate positive and negative formats, use a semicolon. Type: \# "$#,##0.00;\-$#,##0.00".
Ensure the complete field code looks like this: { MERGEFIELD Your_Amount_Field \# "$#,##0.00;\-$#,##0.00" }.
Press Alt+F9 again to hide the field codes. Then press F9 to update the fields, or use the 'Preview Results' button in the Mailings tab to see your negative numbers formatted with a minus sign.

Adjust Windows Number and Currency Formatting Settings
If the picture switch does not work, your system's regional settings might be forcing negative numbers to display in parentheses.
Format Mail Merge Easily with WPS Writer
WPS Writer provides a seamless and highly compatible mail merge experience. You can easily apply standard field codes and picture switches to format your data exactly as needed without relying on complex workarounds.
- 1. Open your document: Launch WPS Writer and open your mail merge main document.
- 2. Access Mailings tools: Navigate to the 'References' or 'Mailings' tab to connect your data source and insert your desired merge fields.
- 3. Toggle field codes: Right-click the inserted merge field and select 'Toggle Field Codes', then add your formatting switch (e.g., \# "$#,##0.00;\-$#,##0.00").
- 4. Preview results: Click the 'View Merged Data' button to verify that your negative numbers display perfectly with a minus sign.

Frequently Asked Questions
What does the semicolon do in the numeric picture switch?
In a numeric picture switch like \# "$#,##0.00;\-$#,##0.00", the semicolon acts as a separator. It tells the program to apply the format before the semicolon to positive numbers, and the format after the semicolon to negative numbers.
Why do my numbers still show in parentheses after adding the field switch?
This usually happens because your Windows Regional Settings are strictly configured to display negative numbers in parentheses. You need to open the Windows Control Panel, go to Region > Additional settings, and change the negative format for both Numbers and Currency to use a minus sign.
How do I easily switch between viewing field codes and the merged data?
You can quickly toggle between displaying the merged data and the underlying field codes by pressing Alt + F9 on your keyboard. Alternatively, you can right-click a specific field and select 'Toggle Field Codes'.
Can I format dates in a mail merge using a similar method?
Yes, but dates require a date-time switch (\@) instead of a numeric picture switch (\#). For example, adding \@ "MMMM d, yyyy" inside your date merge field will format it beautifully, such as 'January 1, 2024'.




