?
Solved

Microsoft Word Switch to convert numbers to words.

Posted on 2009-04-21
2
Medium Priority
?
1,081 Views
Last Modified: 2012-05-06
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.  


0
Comment
Question by:Birdsemple
  • 2
2 Comments
 
LVL 37

Accepted Solution

by:
Joanne M. Orzech earned 2000 total points
ID: 24198973
Hmm - I don't know if you're going to have much luck on the third party market since I don't think the way you are writing numbers is universally accepted... perhaps that is how it is written in the U.K.?  But I have worked for lawyers in the U.S. since 1971 and we have never added the "and"....

Also see
http://www.grammarbook.com/numbers/numbers.asp
Rule 7. With numbers that have decimal points, use a comma only when the number has five or more digits before the decimal point. Place the comma in front of the third digit to the left of the decimal point. When writing out such numbers, use the comma where it would appear in the figure format. Use the word and  where the decimal point appears in the figure format.      
     Examples:
       $15,768.13: Fifteen thousand, seven hundred sixty-eight dollars and thirteen cents
       $1054.21: One thousand fifty-four dollars and twenty-one cents

I know all of this is not very helpful, but just thought I'd toss it out there.

For what it's worth, we use the Dollars to Text macro from Say.
0
 
LVL 37

Expert Comment

by:Joanne M. Orzech
ID: 24224876
Thank you.

Joanne
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
I came across an unsolved Outlook issue and here is my solution.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question