how do I convert number to text in excel

L

Luke M

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top