Hi,
I want convert numeric value to English word,
EXAMPLE
100 CONVERT TO hundred
151 convert to ONE FIFTY ONE
I NEED A FORMULA ONLY, I DON'T NEED VB CODE, PLS HELP ME,
"=SpellNumber" Function not available in my excel
Hi,
I want convert numeric value to English word,
EXAMPLE
100 CONVERT TO hundred
151 convert to ONE FIFTY ONE
I NEED A FORMULA ONLY, I DON'T NEED VB CODE, PLS HELP ME,
"=SpellNumber" Function not available in my excel
maybe you can use this file
convert.JPG
type the numeric in column B, and the result in column D,
could you attach / capture the problem show ("#VALUE!" for the number "99999990.5785)
conver.PNG
I think I knowed why your file could be error, cause you used office version 2002, and the file I attached using office version 2010, and the formula in office 2010 version, not available in office 2002 version
convert error 2.PNG
convert error.PNG
Last edited by fandi_Damore; 01-09-2015 at 08:51 AM.
hi i tried spellnumber function in eglish it is ok
but i need this function in azerbaijanian language
it is very necessary can anyone help me?
1- bir
2- iki
3- üç
4- dörd
5- beş
6- altı
7- yeddi
8- səkkiz
9- doqquz
10- on
11- on bir
12- on iki
13- on üç
14- on dörd
15- on beş
16- on altı
17- on yeddi
18- on səkkiz
19- on doqquz
20 - iyirmi
30 - otuz
40- qırx
50- əlli
60- altmış
70- yetmiş
80- səksən
90- doxsan
100- yüz
1000- min
million- milyon
billion- milyard
trillion- trilyard
currency manat qəpik
dollar- manat
cent- qəpik
manutd275
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks