Converting values which are in Numeric format to word format

[Frnc]

I have a sum total of figures in numeric value eg: $5000.00 i want the same
in words format ie. USD Five Thousand Only.

How can i do the same using formula?

 

[Bob Phillips]

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)