Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert digital #'s to spelled out words
Is there a way to turn you numbers into spelled out words?
Example 24 = twenty-four |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert digital #'s to spelled out words
See:
http://support.microsoft.com/default...N-US;q140704&; -- Gary''s Student "Sarahbkelly" wrote: Is there a way to turn you numbers into spelled out words? Example 24 = twenty-four |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert digital #'s to spelled out words
Hi Sarah,
You could download Laurent Longre's MoreFunc addin which is freely downloadable at: http://xcell05.free.fr/ The addin includes the NBTEXT function which converts a positive number into spelled-out text (supports 13 languages). Also see: http://support.microsoft.com/default...b;en-us;213360 'How to convert a numeric value into English words in Excel' and http://support.microsoft.com/?scid=kb;en-us;259663 'How To Convert Currency or Numbers into English Words' If you are not familiar with macros, you may wish to visit David McRitchie's 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm --- Regards, Norman "Sarahbkelly" wrote in message ... Is there a way to turn you numbers into spelled out words? Example 24 = twenty-four |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert digital #'s to spelled out words
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert digital #'s to spelled out words
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 Thu, 19 Jan 2006 14:39:02 -0800, "Sarahbkelly" wrote: Is there a way to turn you numbers into spelled out words? Example 24 = twenty-four Gord Dibben MS Excel MVP |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert digital #'s to spelled out words
"Sarahbkelly" wrote: Is there a way to turn you numbers into spelled out words? Example 24 = twenty-four |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to convert decimal numbers to words | Excel Worksheet Functions | |||
Excel should have a formula to convert number into words | Excel Worksheet Functions | |||
Convert number into words | Excel Discussion (Misc queries) | |||
how do i convert numbers in figures into words? | Excel Discussion (Misc queries) | |||
how do i convert figures into words in excel? | Excel Discussion (Misc queries) |