number convert into words

which formula I use for number or currency convert into text or words
like ($10220.00) convert into (Ten Thousand Two Hundred Twenty US Dollars &
Zero Cents Only).

Tahir,

take a look at http://xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

"Tahir Imran" <Tahir [email protected]> wrote in message
news:[email protected]...
> which formula I use for number or currency convert into text or words
> like ($10220.00) convert into (Ten Thousand Two Hundred Twenty US Dollars
&
> Zero Cents Only).

test: ignore
--ron