converting to text

simon · Sep 17, 2004

does anyone know how to convert a cell with a numeric
value in to show as a text value
ie. if "1" is entered "one" is shown

GerryK · Sep 17, 2004

=NUMTEXT(A1) but you need to get 'morefunc' add in. Search
Google for it.

Gord Dibben · Sep 17, 2004

Simon

Have a look at the KB article here to build your own Function

http://support.microsoft.com/support/kb/articles/Q213/3/60.ASP

OR Download MOREFUNC.XLL from Laurent Longre's site. Does this(NumText) and
much more.

http://longre.free.fr/english/index.html

Gord Dibben Excel MVP

How can you convert a text value to a numerical formula ?	16	Sep 1, 2010
how to convert a numeric value in text	2	Aug 21, 2008
Convert Text to numeric Value	8	Nov 24, 2008
Function/Formula for Text Conversion	3	Oct 24, 2008
Convert Numbers to Text	2	Sep 18, 2010
Lookup Function	2	Apr 16, 2009
Converting Text	9	Jun 28, 2012
Special string convertion to date and time	4	Feb 1, 2012

Ask a Question