Converting Numbers to Text within Word
Updated Aug 5th, 2024
Who is this guide for?
Case Management Supervisors and System Supervisors
A how-to guide for converting numbers into text within Microsoft Word
Some legal documents will require monetary amounts to be displayed in numbers and words. This guide explains how to convert a monetary value to text within Microsoft Word.
Less than 1 million
When working with numbers less than 1 million, the Microsoft Word \* CARDTEXT function can be used as follows (the \*Upper switch converts the text to upper case):
{YourMergeField \* CARDTEXT \*Upper}
If your merge field YourMergeField displayed as 10,515 the field above would display
TEN THOUSAND FIVE HUNDRED FIFTEEN POUNDS
Numbers over 1 million
As the cardtext feature is only for up to 999,999, any values above this will provide an error.
Using CTRL + F9, create {} within your word document and manually enter the formula below, inserting your merge fields in the {YourMergeField} areas. NB – copying and pasting the below text will not work as Word requires the fields to be entered as formulas.
{ SET largenumber {YourMergeField} }
{ SET remainder {=MOD(largenumber, 1000000)} }
{ SET millions {=INT(({largenumber}-{remainder})/1000000)} }
{IF millions = 0 “” “{REF millions \*CardText \*Upper \*MERGEFORMAT} MILLION “}
{IF remainder = 0 “” “{REF remainder \*CardText \*Upper \*MERGEFORMAT}”} POUNDS
When the document is merged, the data should appear as below.
2,589,570 will be shown as
TWO MILLION FIVE HUNDRED EIGHTY-NINE THOUSAND FIVE HUNDRED SEVENTY POUNDS