Tom's Guide | Tom's Hardware | Tom's Games
 |
 |
 |
I have a list of numbers and I want to convert all these numbers to text, is there any way or formula in excel to do so.
For example I have (1) convert (one)2 (two)
3 (Three) and so on.
I shall be greatly thankful.Abdul Naseer Ansari
Afghanistan
Do us a favor...
Give us a few examples of the actual numbers you want to convert.
If it's really just 1, 2, 3, etc. there are multiple ways to do it.
On the other hand, if you have numbers like 127 or 1,555 or (worse yet) 12.43, then it gets considerably more complex.
0 
Also look here:
http://xl.barasch.com/cCo11432.htm
As written, SpellNumber() converts things like 56.67 to:
Fifty Six Dollars and Sixty Seven Cents
but with a little modification can be used to return:
Fifty Six point Sixty Seven
Scroll down through the code for functions that are a little less complex for numbers like 5, 125, 1234, etc.
0
DerbyDad,
"http://xl.barasch.com/cCo11432.htm" comes up as:
"The page cannot be displayed"Is that URL correct?
(Always like another resourse.)Thanks,
Bryan
0
I clicked on the link in my post and copy/pasted the text from your post in IE6. Both of them took me to this url, which I have just copied from IE6 and pasted back into this post:
http://xl.barasch.com/cCo11432.htm
It could be that one must reach a certain level of nirvana within the spiritual world of all things Excel before you are allowed to access the deep seeded knowledge available to others. When you can snatch the pepples from my hand, Grasshopper...
Kidding!
0
"one must reach a certain level of nirvana..."
I am there with the pebble in my hand.
(Site must have been down when I tried it yesterday.)Thanks, I enjoyed that. :)
Bryan
0
naseer,
Read through the code at the site I offered. There are user-defined functions for various set of numbers, 0 - 9, 10 - 99, 100 - 999. These could be combined and used to test for which set your number belongs in and then convert them.
You could also do it with a simple VLOOKUP table, which could either be manually created or created with the UDF's mentioned above and then converted to text with a Copy/PasteSpecial values.
And don't forget about Bryco's suggestion of the ASAP utlities. I haven't used them in a long, long time so I'm not familiar with the method used there.
0  |
 |
 |
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |
