Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
number to letters
thanks for your help!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
convert number to letters | Excel Worksheet Functions | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Master invoice number | Excel Worksheet Functions | |||
Counting the number of letters in a cell | Excel Discussion (Misc queries) |