Formatting Issues

How to Convert Text or Numbers to Currency Format in Word

Natalie Taylor Oct 9, 2026 874 views

Question details

The user needs to convert numbers stored as text into a standard currency format within a document.

How to Convert Text or Numbers to Currency Format in Word

Product: Microsoft Word
Device & OS: not provided
Scenario: Formatting numbers as currency in a word processing document, especially when dealing with field-generated values like mail merges.
Observed behavior: Microsoft Word lacks direct text-to-currency conversion tools for plain text, requiring the use of field switches or external spreadsheet software to format the numbers properly.

Before you start

Identify whether your numbers are typed as plain text or generated dynamically through Word fields (such as Mail Merge or formula fields) before attempting to format them.

Solution 1Recommended

Apply a Numeric Formatting Switch to a Word Field

Use this method if your number is generated by a Word field, such as a formula or mail merge field, to automatically display it as currency.

While Word cannot format plain text into currency with a single click, it can perfectly format dynamic values pulled from fields using a numeric switch.

Reveal Field Codes

Right-click the dynamic number or field in your Word document and select 'Toggle Field Codes' from the context menu (or press Alt + F9).

Add the Currency Switch

Click inside the field brackets and add the currency formatting switch at the end of the code. For example, type \# "$#,##0.00" to format it as standard US currency.

Update the Field

Right-click the field code once more and select 'Update Field'. The raw number will now display with proper currency formatting.

Apply a Numeric Formatting Switch to a Word Field

Automatic Updates: Once the numeric switch is applied, the field will maintain the currency formatting even if the underlying data or mail merge source changes.

Solution 2

Convert Text to Currency Using Excel

Since Word does not natively convert plain text to currency, use Excel to format the data before pasting it into your document.

Free Microsoft Office alternative

Handle Currency Formatting Easily with WPS Office

Struggling with formatting limitations in Word? WPS Office provides a complete, lightweight suite where you can seamlessly transition between WPS Writer and WPS Spreadsheet to manage your data effortlessly.

1. Download and Install: Get WPS Office from the official website and install the all-in-one suite on your computer.
2. Open Your Document: Launch WPS Office and open your existing Word or Excel files with full layout preservation.
3. Format Seamlessly: Use WPS Spreadsheet to batch format your numbers into currency, then drop them directly into your WPS Writer document.

Free and lightweight alternative to Microsoft OfficeFully compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsSeamlessly copy and paste formatted currency tables from Spreadsheet to WriterFamiliar user interface with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Can I apply currency formatting to plain text directly in Word?

No, plain text cannot be directly formatted as currency using a built-in button in Word. You must either manually type the currency symbol or format the numbers in a spreadsheet program like Excel before pasting them into Word.

What is a formatting switch in Word?

A formatting switch is a special instruction code (such as \# "$0.00") added to a dynamic Word field. It tells the program exactly how to display the raw data, allowing you to turn plain numbers into formatted currency, percentages, or dates.

Why do numbers from my Mail Merge not show as currency?

Mail merge pulls raw, unformatted data directly from your source file (like an Excel list). To display those numbers as currency in your final document, you need to right-click the merge field, toggle the field codes, and append a numeric formatting switch.

Document & File Issues