View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default 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