Can I format a cell to change numerical data from one cell to text data; i.e. A1=1 A2=one Thanks
M Mark Strohmeyer Jul 30, 2003 #1 Can I format a cell to change numerical data from one cell to text data; i.e. A1=1 A2=one Thanks
G Gord Dibben Jul 30, 2003 #2 Mark No built-in Format or Function, but you can build your own User Defined Function using the info at: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213360 OR download Laurent Longre's MOREFUNC.XLL from here: http://longre.free.fr/english/index.html Has a Numbers to Words Function along with many other useful Functions. Gord Dibben Excel MVP - XL97 SR2 & XL2002
Mark No built-in Format or Function, but you can build your own User Defined Function using the info at: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213360 OR download Laurent Longre's MOREFUNC.XLL from here: http://longre.free.fr/english/index.html Has a Numbers to Words Function along with many other useful Functions. Gord Dibben Excel MVP - XL97 SR2 & XL2002
