A adeel via OfficeKB.com Jun 28, 2007 #1 Please tell me the formula to convert Number value to Text value (eg. 10,000 convert to Ten Thousand) thanks
Please tell me the formula to convert Number value to Text value (eg. 10,000 convert to Ten Thousand) thanks
N Niek Otten Jun 28, 2007 #2 Look here: http://xldynamic.com/source/xld.xlFAQ0004.html -- Kind regards, Niek Otten Microsoft MVP - Excel | Please tell me the formula to convert Number value to Text value (eg. 10,000 | convert to Ten Thousand) | thanks | | -- | Message posted via OfficeKB.com | http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200706/1 |
Look here: http://xldynamic.com/source/xld.xlFAQ0004.html -- Kind regards, Niek Otten Microsoft MVP - Excel | Please tell me the formula to convert Number value to Text value (eg. 10,000 | convert to Ten Thousand) | thanks | | -- | Message posted via OfficeKB.com | http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200706/1 |
B Bernard Liengme Jun 28, 2007 #3 Some more: 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: 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
