Num convert to Char.
 

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

Num convert to Char.
 

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

Num convert to Char.
 

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

"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

Num convert to Char.
 

This file might be a help:
http://www.bygsoftware.com/examples/...s/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains the "SPELLNUMBER" function, which can be used in your
spreadsheets, two methods to convert numbers to words and two cheque
writing routines.

The code is open and commented.


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"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