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)