Document Editing Problems

How to Spell Out Currency and Cents in Word Mail Merge Fields

Maira Mehtab Sep 21, 2026 868 views

Question details

The user wants to format a mail merge field so that currency cents are spelled out as text (e.g., 'and sixty-six cents') rather than appearing as a fraction.

Product: Microsoft Word
Device & OS: not provided
Scenario: Generating a mail merge document where currency values need to be written entirely in words.
Observed behavior: When using the {MERGEFIELD Amount \* dollar text} switch, the cents portion displays as a fraction (like 66/100) instead of being spelled out as text.

Before you start

Verify that your data source is correctly linked to your document and that your currency values are stored as raw numbers rather than pre-formatted text.

Solution 1Recommended

Use Nested Field Codes to Spell Out Dollars and Cents

Manually construct a nested field using mathematical functions and the CardText switch to convert both integers and decimals into text.

The default '\* dollar text' format is designed for checks and naturally outputs cents as fractions. To bypass this limitation, you can use mathematical field formulas including QUOTE, SET, INT, MOD, and CardText to spell out values up to $999,999.99.

Insert Field Braces

Press Ctrl+F9 on Windows or Cmd+F9 on Mac to insert functional field braces. Do not type curly braces manually on your keyboard.

Isolate the Whole Dollar Amount

Construct the first nested field using the SET and INT functions to isolate the whole dollar amount. Apply the '\* CardText' switch to spell out the numbers.

Extract the Cents Value

Create another nested field using the MOD function to isolate the cents value, and again apply the '\* CardText' switch to convert it to text.

Combine with a QUOTE Field

Wrap these calculations inside a QUOTE field to output the combined string, ensuring that all spaces in the formula construction are preserved exactly as required.

Macro Conversion Available: Because typing complex nested fields is difficult, you can find a macro in Word Mail Merge Tips and Tricks discussions that automatically converts text representations into working fields.

Solution 2

Install a Currency-to-Words Add-in

Use a dedicated third-party add-in to handle the complex conversion of currency values to full text during a mail merge.

Free Microsoft Office alternative

Edit and Merge Documents Easily with WPS Office

If complex field codes and formatting limitations in Microsoft Word are slowing you down, consider switching to WPS Office. It provides a highly compatible, lightweight, and user-friendly environment for your document editing and mail merge tasks.

1. Visit the Official Website: Go to the official WPS Office website to find the free installer.
2. Download and Install: Click the download button and follow the simple on-screen instructions to install the suite.
3. Open Your Document: Launch WPS Writer and seamlessly open your existing DOCX files to continue working.

Fully compatible with Microsoft Word DOCX formats.Intuitive Mail Merge feature for creating personalized letters easily.Free to download and use with a lightweight installation footprint.Familiar interface that requires no learning curve to master.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Word display cents as fractions in my mail merge?

Word's default '\* dollar text' formatting switch is specifically designed to mimic standard check writing, where cents are traditionally represented as a fraction out of 100.

Can I simply type the curly braces for field codes on my keyboard?

No, manually typing curly braces '{}' will not create a functional field code. You must insert operational field braces by pressing Ctrl+F9 on Windows or Cmd+F9 on a Mac.

Is there a single built-in switch to spell out cents in Word?

Microsoft Word does not provide a single built-in option to spell out both dollars and cents. You must use nested field calculations (like CardText, INT, and MOD) or install a third-party add-in.

Document & File Issues