Cell formatting

[Mark Strohmeyer]

Can I format a cell to change numerical data from one cell
to text data; i.e. A1=1 A2=one
Thanks

 

[Gord Dibben]

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