English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

If i enter a number (numeric) in excel worksheet cell, I want to get the same in WORDS in another cell. Is there any formula?

2006-12-26 22:12:02 · 7 answers · asked by Prabhakar 1 in Computers & Internet Software

7 answers

Excel doesn't having any predefined function to change number to word, the only way is to write down code for it. Excel support VBA for customised coding, so, you can write your own code to solve these problems. you go throught the link specified below:

it containg a function to do the same.

2006-12-26 22:57:00 · answer #1 · answered by Syed A 1 · 1 0

Your best bet is to create a VBA function. The algorithm would most likely use a 0-base array that would have the corresponding word for each row of the array. This would work if the range of numbers is not too large unless you don't mind typing a lot of WORDs.

But if you're not too fussy, a small array for digits 0 thru 9 could be used with some code to express any size number as a series of digits. Example, number 452 would produce "Four Five Two".

I hope this helps

2006-12-29 10:53:36 · answer #2 · answered by Renaud 3 · 0 0

try this formula "Text (value, text_format)"
where value can be any numeric value or any cell reference. I am not sure about it......but hope it may work.

2006-12-26 23:06:13 · answer #3 · answered by The Answering Machine 4 · 0 0

Go to this site, and I am sure there are others.

http://www.ozgrid.com/VBA/ValueToWords.htm

John

2006-12-26 22:28:36 · answer #4 · answered by jrs60660 2 · 1 0

Yes, just type it.

2006-12-26 22:45:28 · answer #5 · answered by sunil p 3 · 0 0

I hope its not possible

2006-12-26 22:15:13 · answer #6 · answered by Prasanna 1 · 0 1

you cannot

2006-12-26 22:13:45 · answer #7 · answered by 120 IQ 4 · 0 1

fedest.com, questions and answers