Converting values which are in Numeric format to word format
 

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?

Converting values which are in Numeric format to word format
 

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)

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