| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How to convert Numbers into text
How to convert Number into Text e.g.
If i enter 10,000 in one cell then Ten Thousand appear in another cell. wat will be the formula for it? |
|
#2
|
|||
|
|||
|
http://support.microsoft.com/default...b;en-us;213360
S. Majid Hussain wrote: How to convert Number into Text e.g. If i enter 10,000 in one cell then Ten Thousand appear in another cell. wat will be the formula for it? |
|
#3
|
|||
|
|||
|
How to convert Numbers into text
"Rowan" wrote: http://support.microsoft.com/default...b;en-us;213360 S. Majid Hussain wrote: How to convert Number into Text e.g. If i enter 10,000 in one cell then Ten Thousand appear in another cell. wat will be the formula for it? |
|
#4
|
|||
|
|||
|
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 - "S. Majid Hussain" <S. Majid wrote in message ... How to convert Number into Text e.g. If i enter 10,000 in one cell then Ten Thousand appear in another cell. wat will be the formula for it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
| convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
| How to reformat numbers stored as text (apostrophe at beginning) | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Convert text to numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
