Recently one of my readers asked me the question how to convert numeric value in to word, This is an important function
everybody looking for in excel but unfortunatly there is no ready to use formula, function in excel. however microsoft provides a visual basic function script in their support section. This script is useful for spelling number in to US dollar.
Accountinghead is converted this function script for the use of indians with the help of some VB experts. Letus do it with easy 5 steps , by using this script you can convert number in to indian Rupees.
- Download the script from here
- Open excel then Press Alt+F11 to start visual basic editor
- In visulal basic editor click insert menu then open module
- Open the downloaded notpad for script, copy the script and paste in opened module window, on the left side pane click on This work book
- Press Alt+Q to save the file.
Now save the excel workbook on your hard disk. For MSoffice 2007 You need to select Save as type = Excel Macro enabled Work book. In excel 2003 you can directly save as xls file.
You are created a new excel function called ntow
How to use the function Number to word
In excel 2007 you need to enable macros before typing function. As you have saved the work book macro enabled, you can see a warning message just under the menu tab like this .
Click on options, a new window appear,click on enable this content.you are done.
Now you have Rs 1555 in cell A1 and you need the number in words cell A2 type in cell A2 =ntow(a2)
Press enter, the amount in words will have displayed.
If you dont want the rupees element, remove the following code from the script
If Val(Left(FIGURE, 9)) > 1 Then
Ntow = “Rupees ”
ElseIf Val(Left(FIGURE, 9)) = 1 Then
Ntow = “Rupee ”
End If
You can also use this function as
=ntow(1500 ) the number will be converted in to words in the same cell.
Awesome! many thanks. was searching for this from long time.
[Reply]
thanks, good formula.
but not work with other file, only work with single file.
pls update this.
[Reply]
Lot ,lot lot………….. thanks…………….
[Reply]
great great
Limitation: stored in the particular file
but its really appreciated
[Reply]
Awesome really Appreciated it work in 2010 also……………………thanks
[Reply]
PLEASE SIR HELP ME
MUJE GUJARATI WORDS ME YE SCRIPT BANANA HE TO SIR MUJE YE BATANA KI YE JO (TENS) HE WO KASE HATANA HOGA…..
KYUKI GUJARATI ME (TWENTY ONE,TWENTY TOW,TWENTY THREE,…………) AISA NAHI AATA TO PLEASE SIR ITNI SI HELP KARNA…..
AUR GUJARATI ME AISE WORDS HOTE HE…
WORDs(1) = “áë»”
WORDs(2) = “Ïë”
WORDs(3) = “ÝÇ”
WORDs(4) = “¿âÓ”
WORDs(5) = “Íâï¿”
WORDs(6) = “À”
WORDs(7) = “ÖâÈ”
WORDs(8) = “áâÄ”
WORDs(9) = “ÌÕ”
WORDs(10) = “ÊÖ”
WORDs(11) = “áã½ÒâÓ”
WORDs(12) = “ÏâÓ”
WORDs(13) = “ÈëÓ”
WORDs(14) = “¿îÊ”
WORDs(15) = “ÍïÊÓ”
WORDs(16) = “ÖíÛ”
WORDs(17) = “ÖÈÓ”
WORDs(18) = “áÆâÓ”
WORDs(19) = “áí½ÇäÖ”
WORDs(20) = “ÕäÖ”
WORDs(21) = “áëÕäÖ”
WORDs(22) = “ÏâÕäÖ”
WORDs(23) = “ÈëÕäÖ”
WORDs(24) = “¿íÕäÖ”
WORDs(25) = “Íc¿äÖ”
WORDs(26) = “ÀvÕäÖ”
WORDs(27) = “ÖÈâÕäÖ”
WORDs(28) = “áQâÕäÖ”
WORDs(29) = “áí½ÇÝäÖ”
WORDs(30) = “ÝäÖ”
WORDs(31) = “áë»ÝäÖ”
WORDs(32) = “ÏÝäÖ”
WORDs(33) = “ÈëÈÓäÖ”
WORDs(34) = “¿íÝäÖ”
WORDs(35) = “ÍâïÝäÖ”
WORDs(36) = “ÀÝäÖ”
WORDs(37) = “ÖâÅÝäÖ”
WORDs(38) = “áâÅÝäÖ”
WORDs(39) = “áí½Ç¿âÔäÖ”
WORDs(40) = “¿âÔäÖ”
WORDs(41) = “áë»ÈâÛäÖ”
WORDs(42) = “ÏëÈâÛäÖ”
WORDs(43) = “ÈëÈâÛäÖ”
WORDs(44) = “¿çÑâÛäÖ”
WORDs(45) = “ÍäÖÈâÛäÖ”
WORDs(46) = “ÀëÈâÛäÖ”
WORDs(47) = “ÖçÑÈâÛäÖ”
WORDs(48) = “áÅÈâÛäÖ”
WORDs(49) = “áí½ÇÍ¿âÖ”
WORDs(50) = “Í¿âÖ”
WORDs(51) = “áë»âÕÌ”
WORDs(52) = “ÏâÕÌ”
WORDs(53) = “ÈëÍÌ”
WORDs(54) = “¿íÍÌ”
WORDs(55) = “Íï¿âÕÌ”
WORDs(56) = “ÀpÍÌ”
WORDs(57) = “ÖÈâÕÌ”
WORDs(58) = “áQâÕÌ”
WORDs(59) = “áí½ÇÖâÚäÄ”
WORDs(60) = “ÖâÚäÄ”
WORDs(61) = “áë»ÖÄ”
WORDs(62) = “ÏâÖÄ”
WORDs(63) = “ÈëÖÄ”
WORDs(64) = “¿íÖÄ”
WORDs(65) = “ÍâïÖÄ”
WORDs(66) = “ÀâÖÄ”
WORDs(67) = “ÖÅÖÄ”
WORDs(68) = “áÅÖÄ”
WORDs(69) = “á½ÇîãÖÈëÓ”
WORDs(70) = “ãÖÈëÓ”
WORDs(71) = “áë»íÈëÓ”
WORDs(72) = “ÏíÈëÓ”
WORDs(73) = “ÈíÈÓ”
WORDs(74) = “¿çÑíÈëÓ”
WORDs(75) = “Íï¿íÈëÓ”
WORDs(76) = “ÀíÈëÓ”
WORDs(77) = “ãÖtÒíÈëÓ”
WORDs(78) = “áÄÒíÈëÓ”
WORDs(79) = “á½Çâáëï×ä”
WORDs(80) = “áëï×ä”
WORDs(81) = “áë»â×ä”
WORDs(82) = “bÒâ×ä”
WORDs(83) = “tÒâ×ä”
WORDs(84) = “¿íÒâô×ä”
WORDs(85) = “ÍïcÒâ×ä”
WORDs(86) = “ÀÒâÖä”
WORDs(87) = “ãÖtÒâ×ä”
WORDs(88) = “áÄÒâ×ä”
WORDs(89) = “ÌëvÒâ×ä”
WORDs(90) = “ÌëÕçï”
WORDs(91) = “áë»âÇçï”
WORDs(92) = “ÏâÇçï”
WORDs(93) = “ÈâÇçï”
WORDs(94) = “¿íÓâÇçï”
WORDs(95) = “Íï¿âÇçï”
WORDs(96) = “ÀnÌçï”
WORDs(97) = “ÖÈâÇçï”
WORDs(98) = “áQâÇçï”
WORDs(99) = “ÌvÕâÇçï”
[Reply]
Very Good Call function
DURGA SHANKAR TANWAR
[Reply]
Very nice its working
[Reply]