View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default 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