Generate Text String

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." <JoeS@discussions.microsoft.com> skrev i melding
news:95C8C7FC-4780-41ED-906E-DC6A7776572C@microsoft.com...
> 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. <JoeS@discussions.microsoft.com>
wrote:

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