Macro to convert numbers to dollars text

N

Neil Intrater

Does anyone have a macro that will convert numbers in dollars to text. For
example, I would like to select:
"456.79"
then run the macro and get:
"Four Hundred Fifty Six and 79/100"

Thanks
 
S

Suzanne S. Barnhill

The \*DollarText switch, which can be added to some fields, will do what you
want. Here's how Word's Help describes it:

Displays results as cardinal text. Microsoft Word inserts "and" at the
decimal place and displays the first two decimals (rounded) as arabic
numerators over 100. The result is formatted in lowercase letters unless you
add a format switch to specify a different capitalization. For example, { =
9.20 + 5.35 \* DollarText \* Upper } displays "FOURTEEN and 55/100".

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top