Link to home
Start Free TrialLog in
Avatar of Birdsemple
Birdsemple

asked on

Microsoft Word Switch to convert numbers to words.

We are currently implementing a new case management system which produces appropriate Microsoft Word documents based on action lists.  

Many of these document need to show a purchase price in both words and figures.  The price is held in a merge field as a number.

The format we need is £250,658 (TWO HUNDRED AND FIFTY THOUSAND SIX HUNDRED AND FIFTY EIGHT) POUNDS STERLING

Currently this is done using the cardtext switch in Word (MERGEFIELD PriceFigures \* CardText \* UPPER).  However the format which that gives us is (TWO HUNDRED FIFTY THOUSAND SIX HUNDRED FIFTY EIGHT)

Unfortunately as these are legal documents we need to have the and in the appropriate places.  I have tried DollarText but that only puts the and in at the decimal place which isnt any help.

Does anyone have any ideas on how we can (or if we can) get the desired format?

Many thanks for your assistance.  


ASKER CERTIFIED SOLUTION
Avatar of Joanne M. Orzech
Joanne M. Orzech
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you.

Joanne