Format cell to show numbers in words

[Rena2j]

If cell F30 is 11,110.45, how do I formulate cell B34 to read cell F30 as
"Dollars Eleven thousand one hundred and ten and cents forty five only.

Help appreciated.

Thanks

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rena2j" <[email protected]> wrote in message
news:[email protected]...
> If cell F30 is 11,110.45, how do I formulate cell B34 to read cell F30 as
> "Dollars Eleven thousand one hundred and ten and cents forty five only.
>
> Help appreciated.
>
> Thanks