Can any one help me and tell me that it is possible, of Typing the Numeric value in one cell and can automatically change in to Alphabetic word, Such As If I Type 1000, it shud come one thousand, like that/
if possible in excel, can anyone send the formula for this/
2006-09-16 22:06:33 · 3 answers · asked by kumaresan_99 1 in Computers & Internet ➔ Programming & Design
Here's a formula for converting digits 1-8 to "one" to "eight." You could build one for multi-digit numbers, though it would be complicated. Note that you type "1" in cell A1,and the answer appears in a different cell, but it sounds like you wanted the text to appear in the same box. I don't know how to do that.
=IF(A1=0,"zero",IF(A1=1,"one",IF(A1=2,"two",IF(A1=3,"three",IF(A1=4,"four",IF(A1=5,"five",IF(A1=6,"six",IF(A1=7,"seven","eight"))))))))
2006-09-16 22:19:14 · answer #1 · answered by ChicagoDude 3 · 0⤊ 0⤋
I've never heard of such a function and, if there is one, it might be in some specialized writing of checks function. After all, one is expected to spell out on checks. Maybe it's only in QuickBooks, or other bookkeeping programs that write checks. Where else would you use it?
You can do it for dates, of course. You know that. But not other numbers, I don't think.
2006-09-16 22:17:13 · answer #2 · answered by auntb93again 7 · 0⤊ 0⤋
Yes you can by writing a function. Have a look at http://support.microsoft.com/default.aspx?scid=kb;en-us;213360
2006-09-16 22:10:10 · answer #3 · answered by Tarak 2 · 2⤊ 0⤋