I am sharing Excel Addin for converting Numbers to Words. I keep getting mails / comments where people are not able to install the VBA code shared in my earlier post
This Addin will make it easier to use. This Addin can be installed on any computer having Excel 2007 and above versions. Once Installed you can use SpellCurr() formula in any excel file on that computer.
You need to download and open Addin file on your machine. This will install the Addin automatically to your machine.
However if you send file to another person you need to send the Addin along and ask that person to install it on his/her machine so that your formula can work there.
Excel Functions : Convert Numbers to Words.
This Addin will make it easier to use. This Addin can be installed on any computer having Excel 2007 and above versions. Once Installed you can use SpellCurr() formula in any excel file on that computer.
You need to download and open Addin file on your machine. This will install the Addin automatically to your machine.
However if you send file to another person you need to send the Addin along and ask that person to install it on his/her machine so that your formula can work there.
Add in Good, but issue I am facing, that I can not use this Add in Excel 2007 Version.
ReplyDeletePls advise
@Diwakar Pls check that you have enabled macros on your machine and you have access rights to use VBA on your machine.
DeleteThanks. Also this Ready Made utility Convert number to indian rupees.
Deletehttp://www.soft.nkworld.in/2012/08/convert-number-to-english-words-in.html
This file "Spellcurr Excel Addin" i downloaded but it is not working ...... anyone can tell me the whole procedure for it ... i am using Office 2010 ... thank you
DeleteDear Yogesh,
DeleteThank you.. this is working for me with the currencies using two decimal places it dont not work for currency which use 3 decimal places. Could you please help me understand how can i use addin those cases...
Thanks..!
DeleteUser can also try free GWORD Multi Currency Converter to Words.
Link - www.gwordformula.blogspot.com
Asalaam o alikum
DeleteSir, Plz tell me that any farmula for convort number to urd word in excel
The above spell currency is brilliant. But is it possible to insert the new "Rupee" sign in this formula. pls suggest.
ReplyDelete@Mehuls - Inserting a Rupee sign is not a Excel Function. For this you need to install Font on your machine and then use the new Rupee Symbol on that machine.
DeleteThanku very much Mr. Yogesh
DeleteThats great Mr. Gupts but i want readymade formula to convert into million format. please send me a link. Thanks in advance
ReplyDeleteThis is Ganga unfortunately downloaded exel file deleted,while i am open any exel document it show error and it should always click OK option to proceed futher proced of work so pls solve my problem.
ReplyDeletewell sir this formula reads only hundreds in figures so if the amount is above lakh then it does not spell in lakh
ReplyDeleteDear Mr Gupta, thanks for addin but when I type =Spellcurr(100000), it shows One Hundred Thousand! We need to make it One Lac or One Lakh! How to do?
ReplyDeleteDear Bharat,
DeleteI also facing same problem with =spellcurr(100000) and above...
mr. yogesh please suggest...for the same.
SpellCurr works on thousands and millions format. If you are looking for Indian format of Lakhs and crores please download another macro from download section of the blog.
DeleteCan u plz send me blog for Indian Format of Lakhs and crores??
Deletepls i also want indian format for lakhs and crores
DeleteDear Mr.Yogesh Guptha,Thanks for your addins for calculating age. I need to calculate the age of a person on a particular date.( eg: age as on 31.03.2012). How can I do this?
ReplyDeletePls replace TODAY() in the age formula with reference to cell containing date 31.03.2012
DeleteI installed your spell currency add-in and it worked like a charm. Very useful.
ReplyDeleteThe users should take a careful look at your recorded video to see the coding for currencies other than the rupee.
Thanks.
Thanks. Also this Ready Made utility Convert number to indian rupees.
Deletehttp://www.soft.nkworld.in/2012/08/convert-number-to-english-words-in.html
I also facing same problem with =spellcurr(100000) and above...
ReplyDeletemr. yogesh please suggest...for the same.
Im trying to write a small vba routine to have excel 2007 connect my access data file. I dont understand the "string" syntax. Can anyone help?
ReplyDeletesir, plz give the ppassword of addin spellcurcency excel 2007
ReplyDeleteWhy do you need the password.. If you just need the code for spellcurr then it is already available at the blog at http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html
DeleteThanks Mr. Gupta :)
DeleteYogesh Sir,
ReplyDeleteThis is very cool stuff and very much useful for me. whether it can read in lakhs, for E.g 2050500 i want spell the amount like this "Twenty lakhs fifty thousand and five hundred only". thank you
great. is it possible to get this without currency code (like rs or dollar)
ReplyDeleteHi,
ReplyDeleteYou have wonderful resource for excel in your site.
Can you help with parsing addresses from different countries into street, city, state, country and zipcode? Note that the addresses are not in any fixed format and there is no standard delimiter.
Good effort yogesg g. i have a invoice template which i use to make invoices. i need a macro or code which automatically print 3 copies + auto save as a copy of invoice with specific cell value as name in specific folder.
ReplyDeletecan u help me plz....
waiting for ur kind reply......
Regards,
Waheed
I cannot download the addin 2003, please advise.
ReplyDeleteKinds regards,
MGL
Add ins is fine and user friendly but how can I convert the currency into Bangladeshi Taka and Paisa.
ReplyDeleteDear Mr Yogesh
ReplyDeleteFirst of all very nice script, but I am facing a problem here. I work in Oman and making a invoice for my company so I use your script. here in Oman Currency is OMANI RIYAL (OMR) and lower multiple is BAISA. Now the problem is that BAISA is having 1000 denomination (means 1000 Baisa is equal to 1 riyal) and when I am placing your script its just taking upto 2 decimal places and also Currency name as Paisa. can you pls tell me how to edit this or give me edited script for the same.
Thnx
Kishor
Thank you for this. I am using Thai Baht and "Baht" and "Satang" never use an "s" to make them plural. Is there a way to remove this s from the text?
ReplyDeleteDear Mr Yogesh
DeleteI have the same issue so it could be very nice if you could address this problem.
In Thai currency there are no "s" at the end. 1 Baht, 2 Baht etc.
How do we fix this?
Thanks
Myke
Thanks
ReplyDeletecan you help how to convert Omani Rials, as 1 Omani Rial contains 1000 Baisa not like another currencies eg 1 Rupee contains 100 Paisa......Like for One Rial Seven Hundred Baisa its showing only seventy baisa
You need to replace the following lines of the code
DeletePaisa = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _
"00", 2))
With
Paisa = GetHundreds(Left(Mid(MyNumber, DecimalPlace + 1) & _
"000", 3))
After this change in the code, you will be able to convert your number to 3 decimals of baisa.
Thnx a lot Sir
Deletecannot get this 3 decimals of baisa
DeleteThank You Very Much...It was very helpful...
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteHi I want to first thank you for the brilliant spellindian formula.
ReplyDeleteI want to know if there is anyway of avoiding paise in the words? I have rounded off in the amount but in the words the paise still comes.
Thanks
Anuj
Hi Yogesh Sir,
ReplyDeleteI am glad to find your site while looking for SpellNumber Function in excel.
I am using Excel 2003. I am working in Namibia, I am dealing with different vendor, which are in different currencies, like US$, Rands, N$, GBP, etc. I did install your excel addin, but still not getting what I am looking for?
Is there any vba code/function which we can incorporate with Spellnumber function?
Thanking you in advance.
Hello Mr. Yogesh,
ReplyDeleteFirst of all thank you as i found the conversion of numbers into words. I then downloaded excel sheet comprising macro (YOGI ANAND's) for the same purpose in Indian style. please convey me regarding convertion of it into add-ins as you have created so that I can escape form repitative procedure of pasting the same macro number of times in every new excel sheet.
Sir
ReplyDeleteI want to convert the following three things of excel 2007 in words
1. Numbers to be converted into hindi words.(Indian formet)
2 Date of bith to be converted in Hindi and English words
3 Numbers converted in English words(Indian formet)
If possible please sent this excel file to my maile guide me.
Mail-pratibhajames@rediffmail.com
jamescheriandpr@yahoo.com
Dear Sir,
ReplyDeleteI want to delete this addin, please advise how to do that.
Thanks
You can uninstall this by following the steps mentioned at following link
Deletehttp://office.microsoft.com/en-us/excel-help/add-or-remove-add-ins-HP010342658.aspx#BMexceladdin
Regards
Dear Yogesh ji,
ReplyDeleteThnx for the SpellCur formula.
I request a slight modification as per my requirement.
I need to convert figure into text without currency name i.e.
(a) 1234 - One Thousand Three Hundred Thirty Four only
(b) 1234 - One Thousand Three Hundred Thirty Four
Please note that each letter is Capitalized
I wud be highly oblidged if u provide me the above two requirements in excel file.
Thnx !
Dear Dhawal
DeleteKindly use following formula along with spellcurr addin
=RIGHT(spellcurr(A1),LEN(spellcurr(A1))-7)
This assumes that your input number is at cell A1, you will need to change as per your data
Thanks
I have an alternate function that has the option to work the way you want (and which has an absolutely huge range of operation) at my mini-blog site here...
Deletehttp://www.excelfox.com/forum/f22/yet-another-number-words-function-sorry-us-style-only-364/
Dear Yogesh Sir,
DeleteThnx ! but can it be a little simpler like say =CONV(A1)
Regards
Dhawal
Thank you Very much sir
ReplyDeleteyou removed a whole load of typing work from my head. this now saves me a lot of time.
Regards
thanks for this code, but i hv one problem after saving this code in module when i click save it says that
ReplyDelete'the following features cannot be saved in macro-free workbooks:
vb project
to save a file with these features, click no, and then choose a macro-enabled file type in the file type list.
to continue saving as a macro-free workbook, click yes
yes no help
i hv selected yes and no also but i hve to copy that code again
when i reopen file it is not asking for enable macros
Deletei think xlsx and xlsm is not supported, its only ask 'enable macro' for xls format.. is it right ?
Deletewhen i protect file with password after that its not asking for enable macros
DeleteThanx for Spell indian would u help me to find duplicate values in coulmn without deleting other duplicate values
ReplyDelete99,99,99,99,99,999.99 = Takas Nine Lac Ninety Nine Thousand Nine Hundred Ninety Nine Crore Ninety Nine Lac Ninety Nine Thousand Nine Hundred Ninety Nine and Ninety Nine Paisas Only``````
ReplyDeleteHow will solve it
I would be most grateful if you could advise me of how to remove the plural from the pence, as this is incorrect in the English language.
ReplyDeleteMany thanks
Hello Sir, I received many datas from many units sum unit rounddown with 2 place of decimal sum units roundup with 2 place of deci would u plz help me to use rounddown & up function in same cell with 2 place of decimals
ReplyDeletewaiting 4 urs valuable reply
how to convert text to RMB (Chinese Yuan)?
ReplyDeletehello, this is helpful but still have problems while converting millions and crores data
ReplyDeleteHi, is there a spellcurr version for microsoft excel 2013? Thanks.
ReplyDeleteThannx a lot Bossssssssssssssssssss...................
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteSir,
ReplyDeleteI hv downloaded this but unable to use.. pl suggest where to keep ( Folder specific) this add in file
This is very cool stuff and very much useful for me. whether it can read in lakhs, for E.g 2050500 i want spell the amount like this "Twenty lakhs fifty thousand and five hundred only". thank you
ReplyDeleteDear Mr.Yogesh
ReplyDeleteThank you very much for the spell curr addin. It would be of great help if an addin could be developed for spellindian as am not able to find the same in your blog.The rupees comes in millions wherein I require the same in lakhs. Pls help.
Dear Mr.Yogesh
ReplyDeleteHave downloaded the xls file developed by Mr.Yogesh Anand converting into Indian currency but how do I incorporate the same into my xls file. Pls guide me.Thanks in advance
Dear Mr.Yogesh
ReplyDeleteThanx for Spell indian would u help me to find duplicate values in coulmn without deleting other duplicate values
Hello Mr. Yogesh,
ReplyDeleteThanks for kind help, this article is very useful, but when i used this formula for Kuwait Dinar, the Fills value is reading only for two digits.
Eg: Five Kuwait Dinars and Fills Fifteen Only (5.150) where as it should be Hundred Fifty Fills, kindly suggest the solution for this.
HI Yogesh,
ReplyDeletei need a support in your curr converter. the problem is in six digits its convert Wrong conversion.
EG. 100000 Rupees One Hundred Thousand Only
" Can we convert in One lakhs "
Thanks worked well
ReplyDeletehi yogesh thanks for your help but when i am trying to converting numbers on another sheets its doesnt work....its only work on your sheets only...is there any other option to save or making sheets.
ReplyDeleteYogesh sir, how do I remove the macro? It needs password to open.
ReplyDeletePls reply.
Dear Yogesh,
ReplyDeleteI have 3 sheets, a, b, and c in a excel file. Cell A1 of sheet b contains number 100. Cell A1 of sheet c contains number 200.
Now in sheet a,
If I input b in cell A1, formula result of cell A2 should give 100
If I input c in cell A1, formula result of cell A2 should give 200
If I manually type =b!A1, or =c!A1 in cell A2, i get the result. I tried =CONCATENATE("=",A1,"!A1") in Cell A2, and typed b in cell A1, I got result =b!A1, instead of 100.
Can you help me out?
Try =INDIRECT(A1&"!A1") instead of =CONCATENATE("=",A1,"!A1")
DeleteThanks a lot Yogesh.
DeleteYour help made my life a lot easier.
I am not a regular visitor to your site. I happened search for converting Rupees in figures to words, and saw your site. I solved my friend's requirement with your spellindian. Then I thought of asking you about my problem which I thought was impossible for last 2 years. After asking you, I almost forgot about it. Today I remembered and checked your site.
It is working!
Thanks again
Dear Yogesh,
DeleteThe query I asked earlier was a simplified one. I tried to incorporate this in my actual excel file, it created a problem. Now I understand that the query I asked was wrong.
Here comes the actual situation.
I have data tables in sheets x1, x2, x3, ....
In my working sheet, in cell B6, I have formula =VLOOKUP($D$26,'x2'!$A$4:$E$8,2)
I want 2 in x2 to be from cell A6.
ie., if I type 1 in cell A6, x2 in formula should change to x1, and i get values from sheet x1.
Is this possible?
Thanking you in advance..
Replace your formula with =VLOOKUP($D$26,INDIRECT("x"&A6&"!$A$4:$E$8"),2)
DeleteDear Yogesh,
DeleteThanks,
Working in my file perfectly
Actually my data sheets are H-1.0, H-0.5, H=0.0, H+0.5, H +1.0, H+1.5, H+2.0
It was not working initially.
I renamed sheets to H1, H2, .... H7, and used a lookup table to get values 1,2,3... corresponding to -1.0, -0.5, 0, .....
Thanks again.
i have copy the code in VBA module but still spell curr fuction is not shown in exel 2013 in windows 8
ReplyDeleteDeepak
Thank you Yogeshji, You are great.
ReplyDeletehow coould i find rs sign insteed of rupees
ReplyDeletehow coould i find rs sign insteed of rupees
ReplyDeletedear yogesh ji , namaskar.
ReplyDeletei have two excel sheet in first sheet(central ware house stock position) A column (code no)B column stock qty.
seccond sheet (branch stock position)A column (code no)B column stock qty.
i have task daily morning i have to compare branch stock position with central warehouse stock position , at present i am printing both sheet and comapare manullay . i want to help from you, how to i know which item is out stock in branch pls provide any formula.
regards
harish
This is siva unfortunately downloaded exel file deleted,while i am open any exel document it show error and it should always click OK option to proceed futher proced of work so pls solve my problem.
ReplyDeleteThanks Ji...Its working fine....Keep on rocking...
ReplyDeleteyogesh i need this ans in spellcurr, -500 , rupees -five hundred
ReplyDeleteyogesh please send me new spellcurr -500, rupees: -five hundred only like this
ReplyDeleteYogesh, thank you so much for the excel add in you created. How would I delete the words ONLY on the translated amount. Instead of "One thousand dollars only" should state "One thousand dollars"
ReplyDeleteDear Mr.Yogesh
ReplyDeleteThank you very much for the spell curr addin. I require same in euro. plz help me
Dear Mr.Yogesh,
ReplyDeleteThis formula reads only hundreds in figures so if the amount is above lakh then it does not spell in lakh - as per below.
174,193 Rupees One Hundred Seventy Four Thousand One Hundred Ninety Three Only
but we need in Indian format.
174,193 Rupees One Lakh Seventy Four Thousand One Hundred Ninety Three Only
This comment has been removed by the author.
ReplyDeleteI need to convert rounded off figure. For example, result for 152.56 should be "Rupees One Fifty Three Only" and result for 125.34 should be "Rupees One Twenty Five Only".
ReplyDeleteIt is very urgent for me. Plz suggest me what to do. Thanks!
Dear Mr.Yogesh,
ReplyDeleteThis formula reads only hundreds in figures so if the amount is above lakh then it does not spell in lakh - as per below.
1,00,000 Rupees One Hundred Only
but we need in Indian format.
1,00,000 Rupees One Lakh Only
please salve it!!!!!!
If you want to know more about "convert number to words in indian format in excel", check this link ........
ReplyDeletehttp://www.exceltip.com/tips/convert-number-to-words-in-indian-format-in-microsoft-excel-2010-2013.html
Dear Yogesh
ReplyDeleteI hv installed spell currency but would need currency in words as
" United States Dollar cents "
pls assist
thanks a lot Yogesh ji.
ReplyDeleteDear Yogesh
ReplyDeleteI havve installed spell currency but would need currency in words as
Rial Omani Five thousand and Baizas 100/1000 only instead of Five Thousand Omani Rials and Baizas One Hundred only
How to delete when it is password protected?
ReplyDeleteNice post, another problem....
ReplyDeleteIs it possible in bengali version (language)?
Sir, I have used MS Access 2007, I need for Indian Currency format in reports, already currency format is 14,144,141 in access, so i need to 14,14,141, Please help me
ReplyDeleteSir, I have used MS Access 2007, I need for Indian Currency format in reports, already currency format is 14,144,141 in access, so i need to 14,14,141, Please help me
ReplyDeleteDear Yogesh,
ReplyDeleteAdd in Good, but issue I am facing, that I can not use 53589.00 Rupees fifty three thousand five hundred eighty nine only instead of this i getting as below:
53589.00 Rupees fifty three thousand five hundred eighty eight and ninety nine paise.
Kinldy help me to solve above problem.
Can you Provide me the password please
ReplyDeleteWhen I close the file and re-open, and when I try to enter formula it require the coding again can I fix the coding permanently please reply
ReplyDeleteMr Arif Saleh Your Problem is your coding enter the coding below I have given.
ReplyDeleteFunction SpellNumber(amt As Variant) As Variant
Dim FIGURE As Variant
Dim LENFIG As Integer
Dim i As Integer
Dim WORDs(19) As String
Dim tens(9) As String
WORDs(1) = "One"
WORDs(2) = "Two"
WORDs(3) = "Three"
WORDs(4) = "Four"
WORDs(5) = "Five"
WORDs(6) = "Six"
WORDs(7) = "Seven"
WORDs(8) = "Eight"
WORDs(9) = "Nine"
WORDs(10) = "Ten"
WORDs(11) = "Eleven"
WORDs(12) = "Twelve"
WORDs(13) = "Thirteen"
WORDs(14) = "Fourteen"
WORDs(15) = "Fifteen"
WORDs(16) = "Sixteen"
WORDs(17) = "Seventeen"
WORDs(18) = "Eighteen"
WORDs(19) = "Nineteen"
tens(2) = "Twenty"
tens(3) = "Thirty"
tens(4) = "Fourty"
tens(5) = "Fifty"
tens(6) = "Sixty"
tens(7) = "Seventy"
tens(8) = "Eighty"
tens(9) = "Ninety"
FIGURE = amt
FIGURE = Format(FIGURE, "FIXED")
FIGLEN = Len(FIGURE)
If FIGLEN < 12 Then
FIGURE = Space(12 - FIGLEN) & FIGURE
End If
If Val(Left(FIGURE, 9)) > 1 Then
SpellNumber = "Rupees "
ElseIf Val(Left(FIGURE, 9)) = 1 Then
SpellNumber = "Rupee "
End If
For i = 1 To 3
If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
If i = 1 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & " Crore "
ElseIf i = 2 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & " Lakh "
ElseIf i = 3 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & " Thousand "
End If
FIGURE = Mid(FIGURE, 3)
Next i
If Val(Left(FIGURE, 1)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 1))) + " Hundred "
End If
FIGURE = Mid(FIGURE, 2)
If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
FIGURE = Mid(FIGURE, 4)
If Val(FIGURE) > 0 Then
SpellNumber = SpellNumber & " Paise "
If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
End If
FIGURE = amt
FIGURE = Format(FIGURE, "FIXED")
If Val(FIGURE) > 0 Then
SpellNumber = SpellNumber & " Only "
End If
End Function
Sir
ReplyDeleteI want to convert the following three things of excel 2007 in words
1. Numbers to be converted into hindi words.(Indian formet)
2 Date of bith to be converted in Hindi and English words
3 Numbers converted in English words(Indian formet)
If possible please sent this excel file to my mail & also guide me.
Mail- kksoni24@rediffmail.com
Thanks.
Can anyone Please provide the addin or anything for convert number to devnagri (Hindi text)
ReplyDeleteI have code for that
DeleteMr. Yogesh, I have not use permanently spellnumber formula in excel, i want to use each and every excel sheet. pls help me for the same.
ReplyDeleteNeed the feature in your android mobile phone ?
ReplyDeleteYou have problems writing your amounts in letters on checks? transfer form? rebate check form?
SpellMyAmount facilitate you all this; you enter the amount in numbers and it writes it for you in letters.
SpellMyAmount is an Android application available on Google Play!
Download it now: https://goo.gl/55u2YQ
Hy.. Can any one guid me ??
ReplyDeleteI want without paisa values convert number in words
This comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThanks...... :)
ReplyDeleteDear Mr. Yogesh,
ReplyDeleteFirst of all, this addin is wonderful. Thanks.
Please provide for USD if possible.
ardalan.yousefpour@gmail.com
Respected Sir,
ReplyDeleteGreat JOB
I have Finding for last 2 years,
Same Formula For Rupees In Words In Gujarati Or Hindi
Can U Help Me ?
i Will ready To type 1 to 1000 in gujarati
please help me sir
Respected Sir,
ReplyDeleteGreat JOB
I have Finding for last 2 years,
Same Formula For Rupees In Words In Gujarati Or Hindi
Can U Help Me ?
i Will ready To type 1 to 1000 in gujarati
please help me sir
i can help you but i dont knw hindi or gujrati i m frm nepal will u type for me in that script than i can help
DeleteThank u sir, I am very glad of ur add in.
ReplyDeleteBut one thing I need a little bit change.
"123.45 = one hundred twenty three dollars and forty five cents only"is the spellcurr conversion. But I need like this "one hundred twenty three and cents forty five only" how to remove dollars and add CENTS between AND & 45?
Dear sir
ReplyDeleteReally very thanks for this
I tried oman currency value its everything OK, but desimal value showing different when baiza comes .900 its showing ninety baiza instead of 900 hundred baiza at the same time .931 baiza correctly showing nine hundred thirty one baiza, same like .930 baiza also showing correctly nine hundred thirty baiza. So only 100,200,300 like showing ten baiza, twenty baiza, thirty baiza respectively
Kindly give me the options if any please
Dear sir
ReplyDeleteSorry I wrongly understood, now its all cleared, thank you so much sir
Dear sir
ReplyDeleteSorry I wrongly understood, now its all cleared, thank you so much sir
Dear Sir
ReplyDeleteCan the number be converted into text through IF Function ? Please suggest
Really very helpful ,I am very great full to you������
ReplyDeleteI can't understand please help me how to use this function in my pc...
ReplyDelete(Rs.64,671.00) HOW REMOVE RS
ReplyDeleteThanks..!
ReplyDeleteUser can also try free GWORD Multi Currency Converter to Words.
Link - www.gwordformula.blogspot.com
good work sir
ReplyDeletegreat add in thanks working smoothly
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteAsalaam o alikum
ReplyDeleteSir, Plz tell me that any farmula for convort number to urdu word in excel
can you help me for num to nepali word rupees in excel
ReplyDeletecan you help me for num to nepali word rupees in excel
ReplyDeletemaile coding garya xu yedi chaiyo vane vannu hola
Delete