| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
| How do I convert char into integer in Excel VBA? | Excel Discussion (Misc queries) | |||
| 8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
| Get rid of CHAR(12) | Excel Programming | |||
| How to removed the first three char and last char in XLS | Excel Programming | |||
![Guy[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
