Format cell to show numbers in words
 

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

Format cell to show numbers in words
 

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

--

HTH

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


"Rena2j" wrote in message
...
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