converting numbers to text

I

Igor T

Hi,
is there a formula that I can use to convert numbers to
text?

similar to =value(cell#) but instead convert number to
text?
Thanks
 
J

Jake Marx

Hi Igor,

Igor said:
is there a formula that I can use to convert numbers to
text?

similar to =value(cell#) but instead convert number to
text?
Click to expand...

Yes - and interestingly enough, it's named TEXT. <g>

Look up TEXT Worksheet Function in Excel help for more info on how to use
it.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
F

Frank Kabel

Hi Igor
if you want to convert a number like 100 to something like 'one
hundred' use one of the following macros/procedures

MS Knowledge Base:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods
 
Top