View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Format or function to turn a number into text.

Nothing built in

http://preview.tinyurl.com/2az4hr


http://groups.google.co.uk/group/mic....programming/b...)


or use an add-in

http://xcell05.free.fr/

download and install Morefunc


--


Regards,


Peo Sjoblom





"Chad" wrote in message
...
I have a formula that spits out a simple number from 1-12, I need that
number
to be expressed as a word (one, two, etc.) instead of the actual number. I
assume there is either a format or a function that I can use that will
convert the number for me, but I haven't been able to figure it out. Any
suggestions?

Thanks