Problem:

Numeric Fields Not Displaying Currency Sign when doing a mail merge.
 

Solution:

TECH TIP: NUMERIC FIELDS NOT DISPLAYING CURRENCY SIGN
 
To change the format of a field merged into an Microsoft Word document, do the following:
 
Press ALT-F9 to view field codes. Doing so will display merged fields as follows:
 
{MERGEFIELD PAYROLL_AMOUNT}
 
Add a field switch to set the format you want. For example,
 
{MERGEFIELD PAYROLL_AMOUNT\# $#,##0.00}
 
will display the merged field from the Access Database (linked to a DB2/400 table) with a dollar sign and commas.
 
For additional information, search Microsoft Word's Help menu's field switches category.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016