how do I convert number to text in excel
Is there a ready file in excel can convert number to text
|
how do I convert number to text in excel
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 |
how do I convert number to text in excel
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 |
how do I convert number to text in excel
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 |
All times are GMT +1. The time now is 09:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com