I want to convert $100,000 to words automatically in excel

Automatically is a bit of an ask but you can do it with this function.

http://www.ozgrid.com/VBA/ValueToWords.htm

Mike

"stephen" wrote:

I want to convert $100,000 to words automatically in excel

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)

"stephen" wrote in message
...
I want to convert $100,000 to words automatically in excel

Some more
Numbers to words
Bob Phillips' site for help on this.

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

or Bernd Plumhoff's site

http://www.sulprobil.com/html/spellnumber.html

or

http://www.ozgrid.com/VBA/ValueToWords.htm

or

http://support.microsoft.com/?kbid=213360

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"stephen" wrote in message
...
I want to convert $100,000 to words automatically in excel