To display dollar in words from number obtain from another cell

[Miles]

Example:

cell A1 shown as $12.05
and I need to get cell A2 to show as Twelve and cents five only automatically.

Please help........

 

[Bob Phillips]

http://www.xldynamic.com/source/xld.xlFAQ0004.html
How To Convert Numbers To Text

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)