number to letters

[Guest]

Is there any way to have a number, for example "163" to be put automatically
into "One hundred and sixty three" ??

thanks!

 

[Gord Dibben]

Ed

No built-in Function, but you can build your own User Defined Function using
the info at:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213360

OR download Laurent Longre's MOREFUNC.XLL from here:

http://longre.free.fr/english/index.html

With either these two Functions the setup would be....enter the number(456) in
A1. In B1 enter =FunctionName(A1)

The KB article names their Function SpellNumber

Laurent's is NUMTEXT


Gord Dibben Excel MVP

Is there any way to have a number, for example "163" to be put automatically
into "One hundred and sixty three" ??

thanks!

Gord Dibben MS Excel MVP

 

[Bearacade]

Check this out from Microsoft:

http://support.microsoft.com/?kbid=21336

 

[Guest]

thanks for your help!