Is there a ready file in excel can convert number to text

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.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Medegypt" wrote:

Is there a ready file in excel can convert number to text

Assuming you mean 1 to One have a look 'here'
(http://support.microsoft.com/kb/213360)


--
mdmackillop
------------------------------------------------------------------------
mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=69232

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 he
http://support.microsoft.com/default...23120121120120

If you are new to user-defined functions (macros), this link to Jon
Peltier's site may be helpful:
http://peltiertech.com/WordPress/200...e-elses-macro/

Hope this helps,

Hutch

"Medegypt" wrote:

Is there a ready file in excel can convert number to text