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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Joanne