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