Generate Text String

[Joe S.]

Is there a method for generating a text string for a number (e.g., 1234
generates "One thousand two hundred thirty four")?

Thanks

 

[Harald Staff]

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

 

[Gord Dibben]

Joe

See Bob Phillips' site.

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


Gord Dibben Excel MVP