I want to convert $100,000 to words automatically in excel
M Mike Apr 4, 2007 #2 Automatically is a bit of an ask but you can do it with this function. http://www.ozgrid.com/VBA/ValueToWords.htm Mike
Automatically is a bit of an ask but you can do it with this function. http://www.ozgrid.com/VBA/ValueToWords.htm Mike
B Bob Phillips Apr 4, 2007 #3 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)
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)
B Bernard Liengme Apr 4, 2007 #4 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
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
