I have made some domestic program for my personal use. I want the excel program to write the number written in one cell in words in another cell. Can anyone tell me the command please? It is urgent.
2006-09-26 23:37:40 · 5 answers · asked by madurainagpur 2 in Computers & Internet ➔ Programming & Design
The microsoft support site has a very involved and probably excelent solution for writing the number in a cell as words on a check. If you want code.
If you want to use only formulas and functions in the worksheet, I suggest liberal use of If and choose functions.
If you use mid() you can separate each number from the rest and knowing their position you can add the appropriate 'hundred' type words.
Choose() function can be used on the individual numbers to get the number words: =CHOOSE(C4,"one","two","three","four")
I only put in up to 4, but if you continue on to nine, it will work for all the digits.
2006-09-30 04:53:15 · answer #1 · answered by Ken C. 6 · 0⤊ 0⤋
There isn't a built-in command for this. You'll have to write it yourself or search the net to find one.
Rawlyn.
p.s. Don't say it's urgent. Of course you want an answer, otherwise you wouldn't be asking, and who wouldn't want their answer sooner rather than later? By asking for an urgent answer, you are subtly implying that your question is somehow of a higher priority than everyone elses. I see that as arrogance.
2006-09-26 23:58:02 · answer #2 · answered by Anonymous · 0⤊ 1⤋
you should visit "device fix" and fix your computing gadget lower back to a time that you comprehend it changed into operating ok. Then get some anti-virus software to guard your computing gadget from destiny attacks.
2016-12-02 03:58:35 · answer #3 · answered by ? 3 · 0⤊ 0⤋
Check this. It has a code which can be used to convert numbers to words
http://support.microsoft.com/default.aspx?scid=kb;en-us;213360
2006-09-27 00:24:16 · answer #4 · answered by Tarak 2 · 0⤊ 0⤋
Check out support.microsoft.com/?kbid=213360
2006-09-26 23:46:07 · answer #5 · answered by Panchi 1 · 0⤊ 0⤋