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
You May Also Be Interested In...
- Rounding values to the nearest fraction in MS Excel
- Get things done fast with keyboard shortcuts for Windows, Word, Excel and Outlook
- ExTools – A free collection of useful Excel functions
- How to change the default file type for Word 2007 and Excel 2007
- Few Excel Tips to make you more productive
- Excel 2007 – The 65535 & 65536 problem
- Open Office 2007 files with older Office versions
- Lesser known Powerpoint Tricks
Subscribe Now
If you enjoyed this post, you will definitely enjoy our others. Subscribe to the feed to get future posts delivered right to your mailbox or feedreader.
Powered by Thesis
An amazing WordPress Theme, nothing beats the versatility and SEO friendliness of the Thesis framework.
From beginners, to the most advanced WordPress developers, Thesis makes it easy for anyone to customize it.
{ 262 comments… read them below or add one }
← Previous Comments
Hi Mr Suresh,
Its a wonderful add-in. If any new tips on excel please send
If any new tips on excel please send to my mail Id. parthi.skumar@gmail.com
Your work is highly appreciated.
Thanks
Parthi
Hi Suresh,
I need the conversion by us dollars instead of INR.
could you please send it to me? My email id parthi.samurai@gmail.com
I thank you in advance for your help.
Reg
Parthi
Hi Suresh, could you send me the modified Addin too… Better yet you can update that in the same post, for others too.
It’s Very Usefull Programme
Its very useful
Please send me your xla password. I need to view the quote.
Please send asap
N. Rajasekaran
dear sir
in my exel 2007 i am not able to find out tools menu where i have to install add ins.
pls advice solution.
Hi Suresh,
Your addin tool is very useful.I have been trying to find this since I 1st started using lotus 1-2-3- way back in the 1983! & at last got it.Thanks.One problem i faced is the RSi nto words is limited to 100 crores as beyond that i get the msg NUMBER TOO LARGE.Have you got an update on this please as I work on huge projects & numbers go even higher.Thanks again.
rgds
Vijay Kumar Rao
18th Aug 2009
thanks a lot for doing such intresting easy convert but please upload .xla file instead of .xls
It IS the .xla file.
but calcuations are not possible after conversion write the program for
calculations also
10 + 10 = 20
after cionversion
Rs. 10 + Rs. 10 = # value
correct this error
If you read the post fully you would notice that the Addin includes the function REVINR for just that purpose.
Dear suresh
Very useful. It ends my long search on this. Keep posting new ideas
Thanks
Namskar Sir,
I’m the user of Office 2007 and tried a lot to copy the file but unable to do so. Kindly guide.
rgds,
m. khandelwal
Thanks Indeed. Solves a lot of sweat.
Wouldn’t it be better to amend ‘Lakh(s)’ to ‘Lac’. It solves the problem of n>100000. More Presentable too!
Hey Suresh
Good one. Thanks.
Hi suresh
I am very happy useing your usefull sureshaddin function in excell sheet.
But i tried to search a option in excell where we can format indian currency for cell by using cell formating option but i am not able to do.
in excell we directly set a format for $ currency by using cell formating
like i need for indian currency
Hai Suresh,
I wanted to use your macro for converting figures in to words. I am not able to run the macro as it is asking the password. Kindly help me out.
Regards
SL Kannan
Thank and very user full tool
Great Job, Cont…………………..
venkat
Mr. Suresh,
I read feedbacks. I think your addins are working very well. Ple tell me how to use your AddIns in Microsoft Office excel 2007. Ple tell me with out fail. I am using msoffice 2007. I need to convert numeric into indian rupees. ie. 1234 is One thousand two hundred and thirty four rupees only.
ple mail me…..
thank’s
Dear Suresh,
Thanks for sharing this………its been a great help. If possible plz share more excel tips that you may have at utkarsh_shikhar@hotmail.com
HI SURESH,
THANKS A TON FOR THIS SOLUTION AS I WAS SEARCHIN THIS FOR SO LONG. FINALLY U GAVE IT . IF U HAVE ANY OTHER ADD INS IN EXCEL PLEASE DO MAIL ME ON “ankur012@gmail.com”
THANKS
ANKUR
9322254845
dear suresh,
wonderful utility. your effort has reduced my effort to a great extent. thanks buddy. just a suggestion, on using inr() function, it shows the following:
456-> Rs. 4,56 (could you pls make it look like Rs. 4,56/- )?
thanks in advance
rajesh
vadodara.
Hi suresh,
I have been using this particular add-in for a quite long time now without any problem. but last week i bought the new PC with OS of XP and Office 2003 and tried to install the add-in. It is showing Add-in in excel – tools add-in but is not displaying the desired results.
kindly let me know why this is happening ??
Dear Suresh,
Your works are so helpful. I thank u so much.
John, Chennai
Amazin solution….Hats off yaar….
Can u mail the code pls… for customising it in our org..pls.
Hi soresh this si good effort from u. When i rename this file or change the location of this file so that conversion did not work
Hai suresh
It simple and wounderful, it is possible to remove “rupees” as I required some times in dollar, euro, INR and other
Pls inform
Thanx and all the best !!!
hello Rajesh,
The “SURESH ADDIN” is good enough for INR conversion,
i am also having the same problem as yous of different currencies values.
have you got the solution for that.
Well if you have then please send it to me over the email
tanwar.g@gmail.com
Regards,
Gaurav Tanwar
Hi Suresh,
Fortunately or unfortunately i landed up in this page. from what I was searching for. You code to change number to words was very useful for me.
Thanks you thank you so much for helping out people like me.
Can I have you mail ID so that i can disturb you gaain if needed, please!
Regards,
Jagadeesh. S
Hi Suresh,
Finally i have got what i was looking for. A million thanks for the add in. It was a wonderful tool and have made my life easy.
Thanks once again…
Pankaj Bajoria
The programme is verymuch use full for us. We are thankful to you sir. If avialble please send me the software regarding converting the scan file to MS word.
Hi Suresh,
How can I enter similar data automaticaly in two work book in same time. If u have any formula please mail me.
Thanks in advance and hoping for reply
Say, you have some data in Book1. Just copy the range of cells, including empty cells where you would be entering data in future. Now open Book2 and click on the cell where you want the data to appear. On the Edit menu, choose the option Paste Special and then choose Paste Link. That should do the trick. Any changes you make to Book1 in the given range will automatically be updated in Book2
i am using the same add ins in excel 2007. Open excel 2007 and right click at the end of the quick acess tool bar u will a options as follows; customise quick acess tool in that menu see left side menu their u will get add ins in the right side window u get the details what add ins are u have, below that manage: excel addins here click go it will show u the un installed addins u have select suresh addins and click ok then it will automatically installed. I have both 2003 and 2007 and i used it for 2003 so while i do so, the addins shows automatically in 2007, if fress 2007 means do as above and select browse button and select the suresh addin where u kept then it will work.
it is working in better and it saves lot of time but it confusing while i transffer from one system to another system through pendrive again i have to use cntr “f” their i have to replace all comand to save the time.
Thanks you very much Mr. Suresh
Dear Suresh,
I have read most of the comments. Pls can you let us know is it possible in 2007? Its great utility. we would love to have this utility.
Thanks
surekha
I’ve been using this addin in Excel 2007and requires no special procedure.
Hi Suresh,
I just love the Addin.. please if you dont mind please forward me the Password i just want to show the coodind what you have done.. please its my humble request to yoo my mail Id is talk2man007@gmail.com.
Regards,
or send me the code.. please.
for your kind effort i will be greatful to you ever..
Thanks for very useful add-in. When I use the INR function, is it possible to block the converted text to not display decimal values?
hi suresh,
thanks for such a nice add-in.
plz send me the same addin for access too.
Its very good programme
Hi Suresh,
I am very fond of your program. I have been using since last year. In this there is one problem I am facing. It shows “Lakhs” with one i.e. one lakhs twenty thousand only. Is there any way to remove “s” from Lakhs when we are writing “one”?
Thanks and you rocks.
User must use this Add-ins.This is a great one.
Thanks boss u r 2 good , It helps me a lot.
Regards
Sourja
Hi Suresh,
Thanks for this nice program could you please send the password on my Id yog.umapati@gmail.com or just change and send me the addin so that it display Lakhs instead of Lakh(s), i.e. “s” without brackets.
Thank you a tons
Hi Suresh,
Merry Xmas and Happy New Year.
This is a great Addin, I am based in Dubai and here Rs. = Dhs. and Paise = Fils. Also we use the western based hundred thousand and NOT lacs.
Can you amend the addin for the above features or email the code at ninad7 at gmail dot com (ninad7@gmail.com) and I shall amend.
Thanks. Looking forward for a response.
Ninad.
Hi Suresh,
Great addin. I am in Dubai and would like a small modification to your addin. Instead of Rs. I’d like Dhs., Paise = Fils. Also we use the hundred thousand and NOT Lakhs.
If you could modifiy the addin and email me at ninad7 AT gmail DOT com or I could modify the code myself.
Regards and Happy New Year.
Ninad.
Hi Suresh,
I need the conversion by us dollars instead of INR.
could you please send it to me? My email id venusudha@gmail.com
I thank you in advance for your help.
Reg
Venu
I read feedbacks. I think your addins are working very well. Ple tell me how to use your AddIns in Windows XP , Microsoft Office excel 2007. Plz tell me with out fail. I am using msoffice 2007. I need to convert numeric into indian rupees. plz mail me…..
thank’s
ash
Thank you verey very much Mr. Suraish. Main kafi arsay say is add-in ki search ma tha. thanks again
Thanks pal, it is of great help and reduces a lot of mistakes
Pls give me the password to customise in our organisation
Hello Suresh
Thanks for rswords(). I was trying for past 1 week. My work has been made easier now because of this option.
Nithya Kumar
We have a medium sized business which requires prinitng of receipts and bill. We use your addins but we donot need he word rupees or Rs. in the start can you please give me password so we could customise
Thanks in advance
Hi Mr Suresh,
Its a wonderful add-in. If any new tips on excel please send to umeshbv22@gmail.com
If any new tips on excel please send to my mail Id. Your work is highly appreciated.
Thanks
thank u suresh
Hats off to you for ur well use ful add-in.
my humble request is i need lakhs instead of lakh(s) add in file..
please mail me..
also another thing i observed with ur add-in is when i use this add-in
i am not getting justification in continuation Cells
for Example for Rs.150000 its showing Rs.1,50,000 but when i use Rs.10050 in next row its saying Rs.10,050 without leaving 2 spaces that means Rs. 10,050(leaving two spaces after Rs.) hope u understood my problem and hope to solve it
anyways thanks for ur effort
thota srinivas
nalgonda.(ap)
← Previous Comments
{ 6 trackbacks }