Macro to convert numbers to dollars text

  • Thread starter Thread starter Neil Intrater
  • Start date Start date
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
 
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
 
Back
Top