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

Excel does not accept text format!	0	May 19, 2022
Content Control Box Issue - Please Help!	0	Dec 16, 2021
How can the font and size of (all) citation numbers be altered?	1	Sep 20, 2022
Using formula to convert date result to text	3	Aug 3, 2012
How can you convert a text value to a numerical formula ?	16	Sep 1, 2010
Equation editor: Switching All-Professional to/from All-Linear Disaster	3	Feb 27, 2018
MS Project - error message when checking "Critical tasks"	1	Nov 15, 2021
Excel Office 2016	3	Apr 26, 2016

Ask a Question