Microsoft Word Switch to convert numbers to words.

Posted on 2009-04-21
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.


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.  

Question by:Birdsemple
    LVL 37

    Accepted Solution

    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
    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.      
           $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.
    LVL 37

    Expert Comment

    by:Joanne M. Orzech
    Thank you.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
    User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
    This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
    Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now