| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
About NUM to CHAR
I am new in Excel.
I want to convert Number to Character (ie. 1234 to One thousand two hundred thirty-four). Plz let me the procedure. I use BAHTTEXT() formula but their result I found in Thai Language, I need result in English. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About NUM to CHAR
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About NUM to CHAR
http://support.microsoft.com/?kbid=95640
ACC: How to Convert Currency or Numbers into English Words http://support.microsoft.com/?kbid=140704 XL: How to Convert a Numeric Value into English Words So you could write you own function and use that. You could download Laurent Longre's free addin: http://xcell05.free.fr/ morefunc.xll which has a function to do this. -- Regards, Tom Ogilvy "balaneeds" wrote in message ... I am new in Excel. I want to convert Number to Character (ie. 1234 to One thousand two hundred thirty-four). Plz let me the procedure. I use BAHTTEXT() formula but their result I found in Thai Language, I need result in English. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About NUM 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 - "balaneeds" wrote in message ... I am new in Excel. I want to convert Number to Character (ie. 1234 to One thousand two hundred thirty-four). Plz let me the procedure. I use BAHTTEXT() formula but their result I found in Thai Language, I need result in English. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| char() | Excel Discussion (Misc queries) | |||
| FIND 1 char in cell of any 3 char =True | 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 | |||
Hybrid Mode
