This post is about an Excel Add-in that I developed about 6-7 years ago. The Add-In was born out of necessity in my office work.
What we needed was to show a number in the Indian Rupee format as well as display the amount in words. Let me explain. Say we have a figure 12345678. If I just use the currency format it will be displayed as Rs 12,345,678.00. But in India we prefer to use the format Rs. 1,23,45,678.00. That is we use hundreds, thousands, lakhs and crores rather than millions and billions. As far as I know there is no built in method to display it in the Indian format. (I haven’t tried Office 2007 yet.). Before I developed this Add-In we had to do it manually each time up to 50 times a day. This Add-In saved us a lot of time.
The Add-In has 3 functions - INR(), REVINR() and RSWORDS().
The INR() function converts a number to the Indian Style Comma formatted currency as you can see in the snapshot. The commas are placed in the right places separating lakhs and crores. But the result that you get is in the Text Format. So you cannot directly use the result in a formula for calculations. To overcome this issue I have added another function called REVINR().
The REVINR() function simply converts the result obtained from using INR function back to the number format so that you can use it in calculations as demonstrated in snapshot.
The RSWORDS() function converts any number to currency in the form of words. This can be quite useful if you generate your invoices using Excel and you want the amount to be displayed in words.
How to install SureshAddIns?
Installing AddIns in Excel is very simple. First you download the AddIn from the link at the bottom of this post and save it on your computer.
Open Microsoft Excel. Click on Tools>Add-Ins. Click on Browse and navigate to wherever you saved the SureshAddIns.xla and then click OK. You have installed the AddIn.
How to use SureshAddIns?
You can use SureshAddIns by directly entering the functions into a cell like =INR(XX), =REVINR(XX) and =RSWORDS(XX) where XX is the reference of the cell you want to convert.
Another way is to use the Insert Function window which you can open either through the fx button on the toolbar or though the Insert>Function menu. In the category dropdown box choose User defined and you will see the above three functions of SureshAddIns.
You are free to use the Add-In as you like. Please do let me know your feedback. Also, if you find any difficulty in using it do contact me at suresh[at]winsila[dot]com.
Download SureshAddIn
Another useful Excel add-in is this PDF converter that lets you convert PDF to Excel files for easy viewing. You can also convert PDF to Word and other file types. Buy software and see how easy converting PDF to text is today!
If you're new here, you may want to subscribe to my RSS feed or get updates through email. Thanks for visiting!
April 14th, 2007 at 3:49 am
Really good Tip!!!
I was looking for it since long time, finally i found it on this informative website!!!!!
Mr. Suresh is of very helping nature, he will answer your queries very promplty!
April 14th, 2007 at 9:49 am
Hi Suresh
Thanks for the addin.. it exactly met my requirements.. thanks once again.
Gowri Sankar
April 25th, 2007 at 9:56 am
Good work Mr. Suresh. Keep it up. VEry useful addin.
April 25th, 2007 at 11:10 am
@Asad Hafeez, Gowri Shankar & Samira Rao : Thank you very much for your compliments.
April 26th, 2007 at 6:15 am
Thanks for the AddIn. I am in the US and I called my dad this morning and he was describing this format problem in Excel and he wanted me to search and find the addin. Good heavens I googled and came to your site. I hope this will help my Dad. He is a Chartered Accountant. Thanks.
April 26th, 2007 at 2:16 pm
Hi Mythreyee, I too hope your dad finds my AddIn useful. Your trythisrecipe blog is awesome. Will visit it often.
April 27th, 2007 at 10:17 am
Dear friend,
it is very nice one. For days, I thought about it and planned to make it through macros. But some illogical… so I failed.. That time I search google and found your link. I used it. very nice. thank you. I shall follow you for further infn. I bookmarked you and shall notify to my friends.
nice day.
April 28th, 2007 at 10:17 am
Hi Suresh,
I found your addin very useful.Thanks for that. But for huge figures such as 300 crores or more than that, the result is number too large to convert.
April 28th, 2007 at 2:28 pm
Thanks Suresh. This has saved me a lot of time Suresh. My brother needed it Urgently. Thanks a lot again!
However it seems to be not formatting correctly whenthe number seems to exceed a certain digits. Please see below:
=Inr(3334000333) Rs.333,40,00,333.00….Here it fails
=Inr(333400033) Rs.33,34,00,033.00…It works here
Am I doing something wrong. Or is it possible that I can Enhance this Function to more digits?
Thanks,
Raghu.
April 28th, 2007 at 5:18 pm
@ Raghu Vansh Dubey & Sunil: I forgot to mention in my post that there is a certain limit to the largest number you can use the Addin for. You can use it on a number as large as 999999999.99. That is 99 crores.. 99lakhs….99 paise. When I created the Addin that was more than sufficient for our purpose. However, with some basic knowledge of VB or VBA, you can easily modify it to suit your requirement. The AddIn in the post is password protected. If you want an editable version please mail me at suresh@winsila.com.
April 30th, 2007 at 10:19 am
My comp had been behaving a bit wierdly after this ad on
April 30th, 2007 at 10:19 am
@Prema: Could you be a little more specific about the nature of the ‘weirdness’? It may help me to offer you some solution.
May 6th, 2007 at 10:35 am
Suresh
Thanks much for creating this add-on. It is very helpful.
John
May 10th, 2007 at 12:40 pm
Hi Suresh..
Thanks for the editable version. It’s a indeed a great tool. Ever since my collegue told me of such a requirement, I was searching for such a function.
George J
May 15th, 2007 at 10:37 am
hello Mr.Suresh,
This is good,But if i don’t need Rs. & paise mention,Please reply me with this please.
Thank.
May 18th, 2007 at 7:15 am
Good work it very help Ful
May 22nd, 2007 at 10:38 am
Dear Mr.Suresh,
It is a very useful addin.
Thankyou.
May 25th, 2007 at 12:01 pm
Dear Suresh,
Thanks for such a rocking add in function. it was excatly as per my requirements. I will appreciate if you can send source code for the same.:-)
Regards,
May 28th, 2007 at 8:27 am
Thanks for the addin.. it exactly met my requirements.. thanks once again.
PLEASE GUIDE HOW TO CALCULATE TWO CELLS TOTAL IF
INR() IS USED IN TWO CELL WE CANNOT DO TOTAL EVEN AFTER USING REVINR()
Reply by Suresh: It is pretty simple Mr. Vijay. Suppose the cells A1 and B1 contain the two numbers converted in INR() format, then the formula that you would use in the cell where you want your total is: revinr(A1)+revinr(B1).
Excel Addin Total
May 29th, 2007 at 10:41 am
Sir,
Thanks for the addin. I am able to use the same as I have MS Excel 2003 in my computer. Does this addin work for lower versions like MS Excel 2000 also?
pls clarify,
parvathi
May 29th, 2007 at 10:41 am
Dear Sir,
You have done a very good job, if u have any more such excel tools u please post it here or u can mail me to bhavintr21@gmail.com
Bhavin Thakkar
May 29th, 2007 at 10:42 am
Hi Mr.Suresh,
You have done a very good job,if possiable then do same thing for us$ convert in words same as (=rswords) command for us $& also if u have any more such excel tools u please post it here or u can mail me to jitu[at]sarvoday.com
or jitubhaim[at]gmail.com
June 2nd, 2007 at 10:42 am
Hi Suresh
Today I saw this addin It was really helpfull in my work.
I was really searching for it
Thanks
June 2nd, 2007 at 10:43 am
I like your add-ins very much very helpful
Thank You,
June 13th, 2007 at 8:50 pm
I don’t know if its happening only with me or the AddIn doesn’t works out with MS Office 2003
June 13th, 2007 at 9:01 pm
what I mean to say is it doesn’t calculate the numbers in that format
June 13th, 2007 at 9:27 pm
@Anil: I don’t really why the Addin does not seem to work for you. If you could explain the issue more clearly I could probably help you.
By the way, if it is only the comma format you are interested, instead of using the Addin, you could trying using the following custom number format:
[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00
June 14th, 2007 at 9:51 am
thanks it is what i needed
June 15th, 2007 at 9:22 pm
Thanks - works for me.
Subodh
June 16th, 2007 at 4:07 pm
Dear Suresh,
Your addin is really user friendly. If you have any other addins like this kind please let me know. I love excel very much and i have visited some intresting sites one is mrexcel.com, patools.com where the are promoting some useful addins and contextures.com. I would like to know more about u. My email id is ramakrishnan_173@rediffmail.com
Regds
R.Ramakrishnan
June 18th, 2007 at 3:18 pm
Well, thanks a lot suresh but there is some trouble with the custom format as well, you see it really looks too odd when we use the format with numbers below 1 Lac, and hence we have to keep changing the formt for only those numbers above 1Lac, as there any other good solution for this?
June 18th, 2007 at 3:20 pm
…I mean select all cells and use one format….
June 23rd, 2007 at 5:43 pm
Doest it work in MS Excel Latest Vrsn like (2003 - 2007)
June 23rd, 2007 at 9:34 pm
It does work in 2003. As for 2007, can anyone with Office 2007 who has installed this Addin kindly confirm?
June 29th, 2007 at 12:29 pm
yeah. It does work in Excel 2007. Btw suresh, i’d be grateful if you could mail me the editable version. I deal in figures much much larger than 99 crores…sometimes even thousands of crores.
July 5th, 2007 at 3:18 pm
Suresh,
This works perfect although there are other ways to do it like putting the format of the number as >9999999]”Rs.”##\,##\,##\,##0;[>99999]”Rs.”##\,##\,##0;”Rs.”##,##0
I was however interested in the code because excel as you know does not let do conditional calculations based on the currency formatting of the cell. I was look to take your code and apply for all my currency fields and then checking what currency the field is and using a vlookup to get me the rates for those currencies to show a corresponding value in home currency.
I would appreciate if you could give me a password or an editable version of your spreadsheet.
regards,
Edward
July 17th, 2007 at 10:16 am
Hi Suresh
the above tips in nor working in xl-2007. give me any solution.
July 17th, 2007 at 8:07 pm
@Vishu: I don’t have Excel 2007 and so haven’t tried it in Excel 2007 myself. But if you look in Comment no. 35 Mr.Satya says that it DOES work in Excel 2007. So the problem might be something else. If you could tell how exactly your excel responds to the Addin, I might be able to offer you a remedy.
August 17th, 2007 at 10:47 am
i have a problem using this addings i cant format the negative numbers
September 1st, 2007 at 3:02 pm
Kudos … wonderful job suresh …. do u have more of this kinda thing ……??? Please provide me the links to them if any …..
September 7th, 2007 at 4:37 pm
hi
i dident hear from you any thing
rogers
September 8th, 2007 at 1:09 pm
Hi,
Weldone suresh, it is very useful for me , i pray before God to give more talent to u for solving the problems of other . I have one question , why (s) is coming in lakh , please solve it , thanking u .
September 10th, 2007 at 1:25 pm
Hi Suresh
A very good job done. It is really very useful. Will you please do it in hindi also like रà¥à¤ªà¤¯à¥‡ तीन करोड़ तीस लाख तेंतीस हज़ार पांच सौ सतà¥à¤¤à¤¾à¤ˆà¤¸ और पैसे इकà¥à¤¸à¤ मातà¥à¤° (33033527.61)? I want to try it after getting editable version of your code but I do not know how to type Hindi(unicode)in Visual Basic.
Regards
A K Trehan
September 25th, 2007 at 11:03 am
Dear Suresh,
I was really very thrilled by your Add in. Beacuase I a kind of person who loves to learn new things in excel , as I am very fond of computers.Thank you very much for your exceptionally good addin.
Thank you once again,
Roshan
October 17th, 2007 at 2:11 pm
Great ! Keep it up. Also try if you can include this feature in format cell directly so that if we select the , style we have a choice of selecting the format.
November 2nd, 2007 at 1:15 pm
Thanks suresh,We were searching for the same.
November 5th, 2007 at 4:14 pm
Sir,
I got the news in business line today. immediately i downloaded the addin. But let me know whether the prefix Rs. can be done with.
November 7th, 2007 at 12:08 am
it is not working in office 2007.
November 9th, 2007 at 6:40 pm
Dear Suresh,
The Addin is very usefull. I thank for ur wonderful work. I need the resulting numbers without decimals if the given number does not contain any decimal. Can u send the editable version of the code. Thank u.
November 17th, 2007 at 10:37 am
Dear Suresh ji,
the addin is very useful. i congratulate u on doing stuff like this. Further i have created some a worksheet in which there are various figures, now i want to convert those all figures into $US figures, can u plz send me the help in this regard so that i can put a single command to whole worksheet
regards
November 22nd, 2007 at 3:32 pm
DEAR SURESH,
YOU SHOWED SUCH A EXCELENT WAY IN EXCEL THANK YOU MY DEAR FRIEND……
REGARDS,
D.MURUGANAND
98650 39915
November 23rd, 2007 at 4:35 pm
EXCELLENT
November 26th, 2007 at 7:41 pm
Dear suresh,
I am very glad to see this option.. but can u please help me or guide in the same without prefixing RS and Zero decimal for the same number format
Waiting for your reply
Praveen Kumar
November 28th, 2007 at 8:24 am
Thanks a lot Suresh. This has saved me a lot of time Suresh.But I’m unable to convert huge figures like 300 crores or more than that, the result is “number too large to convert”.
I have some basic knowledge in VBA, I tried to make it through macros , but I failed.
I would appreciate if you could give me the editable version of your Addin.
If possible please do the needfull.
Regards,
December 3rd, 2007 at 4:23 pm
its really a good software
December 5th, 2007 at 11:56 am
Good work in Excel.
December 5th, 2007 at 1:13 pm
Dear Suresh,
Thanks a lot. This is what I was looking for for the
last two years.It works very good.
K.Elango
December 10th, 2007 at 3:52 pm
Suresh, very good and useful addin, it’s just what I was looking for ….. thanks a ton.
December 16th, 2007 at 7:52 pm
A+
Thank you.
December 19th, 2007 at 10:36 am
GR8 job done, do posting such helpfull material whenever available, this will help users like me or with intermediate knowledge.
December 23rd, 2007 at 8:18 pm
I am using your Suresh Addinn. It very amzing… I am try to My program( in Excel ) but it is not working.. But Suresh AddInn works fantastic..Thank you very much Suresh
December 26th, 2007 at 8:04 pm
very very neat addin…useful almost everyday in my small business invoice printing. keep up the good work.
S
January 5th, 2008 at 4:16 pm
Dear Suresh,
Thank U very much.You did a great job.
Regards,
Girish
January 16th, 2008 at 11:55 pm
Dear Suresh,
I am trying the indian currency number format in my salary breakups. the issue is =INR(SUM()), works, but it gives in this format - Rs. 18,00,000.00
Is there an option of getting 18,00,000 alone with Rs. or decimal point?
Thanks, Bhanu
January 21st, 2008 at 1:45 pm
Great tool, Hats off to you, but not working on vista. Pl suggest what to do.
Good job done.
God bless you.
Warm wishes:
Devesh
January 23rd, 2008 at 1:39 pm
Hi Suresh,
you have done a nice job,
but some very very little mistake is
in the How to use ‘SureshAddIns’? > =REVIN(XX)instead of =REVINR(XX)
You can use ‘SureshAddIns‘ by directly entering the functions into a cell like =INR(XX), =REVIN(XX) and =RSWORDS(XX) where XX is the reference of the cell you want to convert.
Thanx & Regards
Prem Kumar.
January 23rd, 2008 at 2:50 pm
@Prem Kumar: Thank you very much for pointing out the error. I have corrected it now.
January 25th, 2008 at 2:37 pm
Excellent!!! Super Stuff !!!
January 30th, 2008 at 10:07 am
HI, MR SURESH,
IS THERE IS ANY ADDINS FOR MS ACCESS THAT CAN CONVERT NUMBERS TO INDIAN CURRENCY WORDS.
MY EMAIL- IS deepbly@yahoo.com.
February 21st, 2008 at 6:27 pm
Thanks, thanks ,Thanks. I tried my best to find this useful tip in the internet for a long time, at last I find it. Its so useful! I really love this guy who share his intelligence to unintelligent peoples. Thanks again.
February 25th, 2008 at 7:19 pm
Great tool, Hats off to Suresh. Thank you very much.
February 28th, 2008 at 7:03 pm
Hi, It is really useful and very good piece of work.
February 29th, 2008 at 12:19 pm
hi suresh …
i want to serch options while using if condition…. any micro script is there ….
February 29th, 2008 at 10:09 pm
@Ravi Varma: I am sorry but I don’t understand your requirement. Could u please rephrase your question so that I can try to give/find u a solution?
March 7th, 2008 at 4:34 pm
Hello Mr Sureshji
Really it is very usefull development.Thank you for this.
DIGESH SHUKLA
ASST LIBRARIAN
MGSIRD, JABALPUR MP
March 16th, 2008 at 11:10 pm
Thanks Suresh for the usefull developed add ins
I m grateful to u for your hard work.
Once again thanks
Anil Parekh
Manager EDP
BLA Coke Pvt.Ltd.
Mithapur 361345
Dist Jamnagar Gujarat India
April 19th, 2008 at 2:26 pm
Sir,
Pls advise is there any option to show INR without showing Rs.
Regards,
Avadhani.
April 19th, 2008 at 3:56 pm
Dear Mr.Suresh,
Thank you very much for Excel AddIn to show Currency in Indian format and Words it is very useful.
April 24th, 2008 at 12:04 pm
Suresh jee
interesting .. good work. i have been looking for this option for long.. u have worked quite well. keep it up and make this more familiar with indian work style.
GOOD WORK..
regards
April 26th, 2008 at 1:06 pm
Lots of Thanks suresh
April 28th, 2008 at 2:35 pm
Hi Suresh, do you have a addin for converting to dhs instead of Rs. Eg: instead for Rs One lakh, it should convert to Dhs one lakh. Thanks
April 30th, 2008 at 1:17 pm
gr8 yaar… u have solved my problem.
May 10th, 2008 at 10:42 pm
Thanks, what a nice addin. It reducess our work very much. Thanks a lot again.
May 22nd, 2008 at 12:46 pm
It solved my Problem-Thanks a Lot
May 24th, 2008 at 7:51 pm
Hi Suresh, Oh Its a great success, i.e. goes to you, Many times I will try in VBA, finally i get very bored. Lastly I decided that this project I will be done in VB with Ms access. But unfortunately I will find your link for converting number to text in indian format, which is very simple that you makes it.
thanks.
May 29th, 2008 at 11:10 am
I want the figure Lac instead of Lack(s)
May 29th, 2008 at 12:21 pm
The Addin is very usefull. I thank for ur wonderful work.Can u send the editable version of the code.
Is there any Add-ins for Microsoft Access that can convert numbers to Indian Currency in words.
Thnx,
May 31st, 2008 at 12:57 pm
Great work! but You have protected you xla file with password and I want the figure in Lac instead of Lack(s) tell me how can I change the same. i will be highly obliged to you, if you do the needful in my favour.
Thanks
@Abhishek - Hi, I am sending you a modified xla file with the word Lac. Hope you find it useful. - Suresh
June 1st, 2008 at 4:47 pm
Thanks Suresh!
If you possible please post the source code of this useful add-in.
June 2nd, 2008 at 3:48 pm
send me SureshAddins
June 2nd, 2008 at 3:50 pm
very good
June 11th, 2008 at 2:42 pm
Dearest Suresh,
Thank you very very very much for posting such an useful addin.
I have a little request, hope you can sort it out.
Instead of Lakh(s), I want to use Lakhs . . .
If possible give me the source code so that I can do it on my own . . . Otherwise you will hae to help me out . . .
Thank you very much once again . . .
Looking forward to your reply . . .
Warm regards
CA Rahul Patel
SHARPEX - Ahmedabad
June 27th, 2008 at 11:50 am
Hi
It’s Asking For Password Can You Please Let Me Know What Is The Password
June 27th, 2008 at 12:00 pm
Hi
It’s Really Fantastic
Thank You So Much
Thanks Again
Sanjay…