G Guest Mar 2, 2005 #1 Is there a method for generating a text string for a number (e.g., 1234 generates "One thousand two hundred thirty four")? Thanks
Is there a method for generating a text string for a number (e.g., 1234 generates "One thousand two hundred thirty four")? Thanks
H Harald Staff Mar 2, 2005 #2 There is no built-in way to do this. You need VBA or an addin, like Morefunc from http://xcell05.free.fr/ HTH. Best wishes Harald
There is no built-in way to do this. You need VBA or an addin, like Morefunc from http://xcell05.free.fr/ HTH. Best wishes Harald
G Gord Dibben Mar 2, 2005 #3 Joe See Bob Phillips' site. http://www.xldynamic.com/source/xld.xlFAQ0004.html Gord Dibben Excel MVP