How to spell out numbers in Microsoft Word

Is there a way to spell out numbers in Word 2010?  Example - $100.00  to One Hundred Dollars.
Is there a way to spell out numbers in Word 2010?  Example - $100.00  to One Hundred Dollars.

You can use the \* cardtext field number format for this. If you bookmark the number amount somewhere on your document (let's call it amnt), then tap Ctrl+F9 to open a set of field braces and type in the following:

{ REF amnt \*cardtext \*caps }  dollars        e.g. One Hundred dollars
... or possibly,
{ REF amnt \*cardtext \*firstcap }  dollars        e.g. One hundred dollars

Tap F9 while still inside the field braces to update the field. See the following article for the \*dollartext format switch as well.

Format (\*) field switch

15 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Ron,

Jeeped's referred you to Microsoft’s 'CardText' field switch, but that doesn’t support decimal values. The 'DollarText' field switch does, but it doesn’t express a value as ‘X dollars and Y cents’ – it returns ‘X and Y/00’. On top of that, neither switch supports values of 1 million or more. Here’s a more sophisticated approach:
{QUOTE {ASK Val "What is the amount?"}"{=INT(Val) \* CardText} dollar{=INT(Val)-1 \# "s;s;"}{IF{=MOD(Val,1) \# 0.00}> 0 " and {=MOD(Val,1)*100 \# 0 \* CardText} cent{=INT(MOD(Val,1)*100-1) \# "s;s;"}"}"}.

 

For something even more sophisticated that, unlike either of Microsoft’s field switches supports the use of 'and' in the strings per standard anglicized expressions, and really large values, you could use a field coded as:

{QUOTE {ASK Val "What is he amount?"}
{SET AbsVal {=ABS(Val)}}
{IF{=Val}< 0 "Minus "}
{IF{=INT(AbsVal/100000000)}<> 0 "{=INT(AbsVal/100000000) \*Cardtext} hundred "}
{IF{=MOD(INT(AbsVal/1000000),100)} <> 0 "{IF{=INT(AbsVal/100000000)}<> 0 "and "}"}
{IF{=INT(AbsVal/1000000)}<> 0 "{=MOD(INT(AbsVal/1000000),100) \*Cardtext} million, "}
{IF{=INT(AbsVal/100000)}<> 0 "{=MOD(INT(AbsVal/100000),10) \*Cardtext} hundred "}
{IF{=MOD(INT(AbsVal1000),100)} <> 0 "{IF{=INT(AbsVal/100000)}<> 0 "and "}"}
{IF{=INT(AbsVal/1000)}<> 0 "{=MOD(INT(AbsVal/1000),100) \*Cardtext} thousand, "}
{IF{=MOD(INT(AbsVal/100),10)}<> 0 "{=MOD(INT(AbsVal/100),10) \*Cardtext} hundred "}
{IF{=MOD(INT(AbsVal),100)}<> 0 "{IF{=INT(AbsVal/100)}<> 0 "and "}{=MOD(INT(AbsVal),100) \*Cardtext} "}
{=INT(AbsVal) \# \dollar;;}{IF{=INT(AbsVal)}> 1 "s"}
{IF{=MOD(AbsVal,1)}<> 0 "{IF{=INT(AbsVal)}<> 0 " and "}{=MOD(AbsVal,1)*100 \*Cardtext} cent{IF{=MOD(AbsVal,1)}> 0.01 s}"} \* FirstCap}.

With the second field you can go all the way to 99,999,999,999.99 but the text expression for the two highest orders of magnitude are not quite right (a bit more code could be introduced for that - but only if it was really needed).

You can omit/edit the:
{=INT(Val) \# \dollar;;}{IF{=INT(Val)}> 1 "s"} and {IF{=MOD(Val,1)}> 0.01 cents cent}"}
portions if you want no/different currency. You could likewise omit the various tests for inserting 'and ', if you prefer.

 

Note: The field brace pairs (ie '{ }') for the above example are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.

 

A macro for converting the above to working fields can be downloaded from: http://www.gmayor.com/export_field.htm#TextToField

Cheers
Paul Edstein
(Fmr MS MVP - Word)

5 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

There is an add-in for this process now:  http://gregmaxey.mvps.org/word_tip_pages/spell_out_currency.html

 

Handles the U.S. National dept up to 99 Trillion (or perhaps through the middle of next year)

Greg Maxey
***
Death smiles at us all, but all a man can do is smile back.


For more help with Word visit:
http://gregmaxey.com/word_tips.html

5 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated March 22, 2024 Views 15,369 Applies to: