software

Is there a way to turn you numbers into spelled out words?
Example
24 = twenty-four

See:support.microsoft.com/default...N-US;q140704amp;;
--
Gary''s Studentquot;Sarahbkellyquot; wrote:

gt; Is there a way to turn you numbers into spelled out words?
gt; Example
gt; 24 = twenty-four

Hi Sarah,

You could download Laurent Longre's MoreFunc addin which is freely
downloadable at:

xcell05.free.fr/

The addin includes the NBTEXT function which converts a positive number into
spelled-out text (supports 13 languages).

Also see:
support.microsoft.com/default...b;en-us;213360
'How to convert a numeric value into English words in Excel'

and
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:

www.mvps.org/dmcritchie/excel/getstarted.htm---
Regards,
Normanquot;Sarahbkellyquot; gt; wrote in message
...
gt; Is there a way to turn you numbers into spelled out words?
gt; Example
gt; 24 = twenty-four
USE

www.codeguru.com/vb/gen/vb_mi...cle.php/c5595/

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

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

OR download Laurent Longre's MOREFUNC.XLL from he

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 NUMTEXTGord Dibben Excel MVP

On Thu, 19 Jan 2006 14:39:02 -0800, quot;Sarahbkellyquot;
gt; wrote:

gt;Is there a way to turn you numbers into spelled out words?
gt;Example
gt;24 = twenty-four

Gord Dibben MS Excel MVP



quot;Sarahbkellyquot; wrote:

gt; Is there a way to turn you numbers into spelled out words?
gt; Example
gt; 24 = twenty-four