80,000 hits on a Google search for "convert numbers to text excel vba" :)
As a freshman, you might want to know there's already tons out there on
Google that you don't have to wait to get the answer. But here's one!
http://www.erlandsendata.no/english/...nloadfunctions
Good luck!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com



"Guy" wrote in message ...
Hi All

I'm a freshman in programming, would you pls help how to convert Number to
Char. (i.e. 100 One Hunder.......)

Regards

Guy