ExcelBanter - number to letters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - number to letters (https://www.excelbanter.com/excel-discussion-misc-queries/93197-number-letters.html)

number to letters

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

thanks!

number to letters

Ed

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

http://support.microsoft.com/default...;EN-US;q213360

OR download Laurent Longre's MOREFUNC.XLL from he

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

On Fri, 9 Jun 2006 15:51:20 -0700, Ed wrote:

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

number to letters

Check this out from Microsoft:

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

--
Bearacade

------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=550499

number to letters

thanks for your help!