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

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

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" <(E-Mail Removed)> wrote in message
news:1BF67EBF-F1AA-4F8F-B58F-(E-Mail Removed)...
> Is there a way to turn you numbers into spelled out words?
> Example
> 24 = twenty-four

USE

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

----
Selvarathinam

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




On Thu, 19 Jan 2006 14:39:02 -0800, "Sarahbkelly"
<(E-Mail Removed)> wrote:

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

Gord Dibben MS Excel MVP

"Sarahbkelly" wrote:

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