Osprey Academy - Customer Support & Training

Using Osprey

Learn how to use Osprey to manage your day-to-day operations and processes


Converting Numbers to Text within Word

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


In this article Related Guides