L Luke M Feb 26, 2009 #2 Why not simply format the cell(s) to "text"? Or, if using formulas, =TEXT(A2) would turn whatever number is in A2 into a text value.
Why not simply format the cell(s) to "text"? Or, if using formulas, =TEXT(A2) would turn whatever number is in A2 into a text value.
T Tom Hutchins Feb 26, 2009 #3 Do you mean you want something that will spell out numbers (for printing checks,e tc.)? If so, you could use Longre's morefunc.xll which is free at http://xcell05.free.fr/morefunc/english/ The number spelling function is called NBTEXT. Or, Microsoft has instructions to create your own SPELLNUMBER function here http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360#XSLTH3121121123120121120120 If you are new to user-defined functions (macros), this link to Jon Peltier's site may be helpful: http://peltiertech.com/WordPress/2008/03/09/how-to-use-someone-elses-macro/ Hope this helps, Hutch
Do you mean you want something that will spell out numbers (for printing checks,e tc.)? If so, you could use Longre's morefunc.xll which is free at http://xcell05.free.fr/morefunc/english/ The number spelling function is called NBTEXT. Or, Microsoft has instructions to create your own SPELLNUMBER function here http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360#XSLTH3121121123120121120120 If you are new to user-defined functions (macros), this link to Jon Peltier's site may be helpful: http://peltiertech.com/WordPress/2008/03/09/how-to-use-someone-elses-macro/ Hope this helps, Hutch
