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

Thanks

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

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

Thanks

Joe

See Bob Phillips' site.

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


Gord Dibben Excel MVP


On Wed, 2 Mar 2005 11:41:02 -0800, Joe S.
wrote:

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

Thanks