Fix Word Mail Merge Currency Field Adding Wrong Symbol for the Locale

When you run a mail merge in Word, currency amounts from your data source may display with the wrong currency symbol. For example, a dollar amount may show a euro sign, or a euro amount may show a pound sign. This happens because Word’s currency field codes use the system locale settings rather than the data source formatting. This article explains the root cause of the symbol mismatch and provides step-by-step fixes to force the correct currency symbol in your merged documents.

Why Word Displays the Wrong Currency Symbol in a Mail Merge

Word’s mail merge retrieves numeric data from a data source such as an Excel worksheet or a database. When you insert a currency field using the Mail Merge wizard, Word applies the \# "$#,##0.00" picture switch by default. The dollar sign in that switch is not a static character. It is a placeholder that tells Word to use the currency symbol from the current system locale. If your system locale is set to a region that uses a different currency, the merged document will show that locale’s symbol instead of the one you expect.

For example, a user in the United Kingdom with a locale set to English United Kingdom will see the pound sign even if the data source contains US dollars. The same problem occurs when the data source column contains formatted currency values rather than raw numbers. Word reads the formatted text and may apply a secondary locale interpretation.

The fix involves replacing the locale-sensitive currency placeholder with a literal character or using a numeric picture switch that does not inherit the system locale.

Steps to Replace the Locale-Dependent Currency Symbol With a Literal Character

1. Open the mail merge main document
   Open the Word document that contains the mail merge fields. This is typically the letter, label, or envelope template you created with the Mail Merge wizard.
2. Display the field codes
   Press Alt+F9 on your keyboard. The merged fields will change from showing values (e.g., $1,234.00) to showing field code syntax such as { MERGEFIELD Amount \# "$#,##0.00" }.
3. Locate the currency field code
   Scroll to the field that contains the currency value. Look for the \# picture switch followed by a currency symbol inside quotes.
4. Replace the locale-sensitive currency symbol
   Change the symbol inside the quotes to the literal character you need. For a US dollar sign, replace "$#,##0.00" with "$#,##0.00" (the same, but ensure the dollar sign is typed directly). For a euro sign, type \# "€#,##0.00". For a British pound sign, type \# "£#,##0.00". You can insert the euro symbol by pressing Ctrl+Alt+E and the pound symbol by pressing Alt+0163 on the numeric keypad.
5. Update the field
   After editing, press F9 to update the current field. Press Alt+F9 again to toggle back to value view. The merged preview should now show the correct currency symbol.
6. Complete the merge
   Run the mail merge by clicking Mailings > Finish & Merge > Edit Individual Documents. Check that all records display the correct symbol.

Alternative Method: Use a Numeric Switch Without a Locale Symbol

If you do not want to hard-code a specific symbol, you can use a numeric picture switch that does not include a currency placeholder. Replace the field code with { MERGEFIELD Amount \# "#,##0.00" }. This removes the currency symbol entirely. You can then type the symbol manually in the document text before or after the merged field. This approach avoids locale interference entirely.

If Word Still Shows the Wrong Symbol After Editing the Field Code

The data source column contains formatted text instead of numbers

When the data source column includes currency symbols as part of the cell value (e.g., “$1,234.00” stored as text), Word treats the entire string as text and ignores the picture switch. Open the data source file in Excel. Select the column, press Ctrl+1 to open Format Cells, and set the format to Number with 2 decimal places. Remove any currency formatting from the column. Save the file, then refresh the mail merge connection in Word by clicking Mailings > Select Recipients > Use an Existing List and reselecting the file.

The system locale overrides the literal symbol in the picture switch

In rare cases, Word may still apply the system locale even after you type a literal symbol. This happens if the field code contains invisible characters or if the locale setting is locked by Group Policy. To force a specific symbol, use the Unicode hex value in the switch. For example, to force a dollar sign, use { MERGEFIELD Amount \# "\u0024#,##0.00" }. Replace \u0024 with the Unicode code point for your desired symbol: \u20AC for euro, \u00A3 for pound, \u00A5 for yen.

The merged document shows the correct symbol in preview but not in the final output

This indicates that the field code is correct, but the document contains multiple instances of the field. Use Alt+F9 to toggle all field codes. Press Ctrl+A to select the entire document, then press F9 to update all fields. Run the merge again.

Comparison of Methods to Fix the Currency Symbol in a Mail Merge

Method	Literal Symbol in Switch	Unicode Hex in Switch
Ease of use	Type the symbol directly	Requires knowing the Unicode code point
Locale interference	May still be overridden by system locale	Ignores system locale completely
Best for	Quick one-off fixes	Documents shared across multiple locales
Symbol variety	Limited to keyboard-accessible symbols	Any Unicode currency symbol available

After applying the fix, you can now produce merged documents with the exact currency symbol required by your data. To avoid future issues, always store currency values as raw numbers in your data source and apply formatting only in Word. As an advanced tip, create a custom Quick Part containing your corrected field code so you can reuse it in future mail merge templates without re-editing the switch each time.