Formatting Issues

How to Display Negative Mail Merge Amounts With a Minus Sign

Ayan MasoodAyan Masood Nov 2, 2026 869 views

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.

How to Display Negative Mail Merge Amounts With a Minus Sign
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.
Before you start

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.

Solution 1Recommended

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.

1
Toggle field codes

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 }.

2
Insert the numeric switch

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".

3
Verify the syntax

Ensure the complete field code looks like this: { MERGEFIELD Your_Amount_Field \# "$#,##0.00;\-$#,##0.00" }.

4
Update and preview

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.

Use a Numeric Picture Switch in the Merge Field
Customizing the Currency Symbol: You can replace the dollar sign ($) in the switch code with any other currency symbol, such as € or £, depending on your regional requirements.
Efficient Mail Merge with WPS Office

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. 1. Open your document: Launch WPS Writer and open your mail merge main document.
  2. 2. Access Mailings tools: Navigate to the 'References' or 'Mailings' tab to connect your data source and insert your desired merge fields.
  3. 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. 4. Preview results: Click the 'View Merged Data' button to verify that your negative numbers display perfectly with a minus sign.
Fully compatible with Microsoft Word document formats and standard mail merge field codes.Supports advanced numeric and date-time switches for precise data formatting.Intuitive Mailings tab makes managing data sources and previewing results simple.Lightweight, fast, and available for free across multiple platforms.
microsoft office alternative - wps office

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'.