An Excel AddIn to show Currency in Indian format and Words

Posted on 30 March, 2007

This item is filed under [ MS Office Tricks, Tips & Tricks ]

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

Share and Enjoy:

If you liked this post, consider subscribing to my RSS feed or get future posts delivered through Email

Tagged with: [ Excel Addin, Excel Rupees format, Indian Rupee Format, Indian Rupees, INR, INR Excel, Rupee Format ]

If you enjoyed reading this article, please check out other related articles below:

{ 4 trackbacks }

bT Square Peg :: News » Blog Archive » Lakhs and Crores in a spreadsheet: June 29, 2007 at 7:34 pm
Anonymous: January 23, 2008 at 10:59 am
Globe Live » Currency in Indian format and Words: November 14, 2008 at 3:24 pm
Number format | keyongtech: January 18, 2009 at 9:49 pm

{ 146 comments… read them below or add one }

← Previous Comments

1 Munazzir Qazi August 7, 2008 at 12:16 am

Hello Suresh,
Thanks for the VBA for converting number to work (in indian currency format). The least I can do is ‘Thank You’ for putting it on the web.
Regards,
Qazi Munazzir

2 istiyaque August 8, 2008 at 11:52 am

It is groovy invetion by you for the user of Excel. My heartiest thanks to you for this great job.

Please give some solution in MS Word in same manner. It will be highly appreciated.

3 feroz August 29, 2008 at 9:35 am

Hi suresh
The addin is asking for password.An error project library not found is also displayed. Pleasae mail me the password or mail me how to overcome this error.

4 AN Rawal & MB Oza August 29, 2008 at 2:32 pm

Dear Suresh,

Really an extraordinary add-in for Excel.
It’s very very useful for major work in Excel.
Again many many thanks for such type of add-in.

Regards,

-AN Rawal & MB Oza

5 Ramesh August 29, 2008 at 3:36 pm

Hi Suresh, This is a great Addin! Is there a way to remove the “Rs.” prefix? Also, I’d like to format negative numbers in parenthesis, with Red color text if possible.

6 Plaban September 15, 2008 at 5:23 pm

Hi Suresh,

Really a Great useful work for excel.
Thanks to you for this job.

Plaban

7 PARRY October 2, 2008 at 12:01 am

MOST URGENT:
Dear, Suresh. You have saved me the trouble of depending on some subordinates to type and print the entire ledgers, folios, books, etc amounts in words of 112 companies. This was a big task every 3 months. Howevere, I would like the version which can transverse 11 digits before decimal into words. How can you help me with that. my email is parry1234(at)gmail.com

8 dev October 11, 2008 at 2:07 pm

thanks suresh ur addin is great n useful to many CA

can u plz send me modified Addin i.e with correction “Lacks”
n how to add “[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00″ in coustom number format permanantly?

9 AZAAM October 14, 2008 at 1:46 pm

dear sir,
its excellent but please help me to qatary riyal please

10 TDK November 3, 2008 at 5:07 pm

How i use such converter in Access form, report or query

Please help me

11 Jyoti November 6, 2008 at 5:56 pm

This is really helpful. Also I need to know suppose value is Rs. 2,80,000.00. I want this to be converted in Rs. 2.8L or lac. Is it possible.

Please mail me your answer whether it is yes or no at jyotigaurr@rediffmail.com

12 pardeep kumar November 11, 2008 at 9:36 pm

kindly provide the formula I am very thankul in this regard

13 Ashwani Malik November 19, 2008 at 2:17 pm

Great Tool
Excellent
You have completeted my Long Pending WIsh
Thank You again
Ashwani Malik

14 Harisankar November 21, 2008 at 10:13 am

Fantastic suresh!!! Great Job

15 rajesh November 27, 2008 at 2:26 pm

hey Suresh u ve done well..

the addin is very useful… thank you.

ofcourse v are getting number format as designed by you that is converting into Rs. & in words. but how get numbers alone ex:12,78,640 without Rs.12,78,640

please find addin for the same

Thank you
Rajesh

16 pardeep December 2, 2008 at 2:46 pm

please provide excel formula as it is very useful to me I shall very thankful for this kind act

17 M.Mariappan, M.Com December 4, 2008 at 10:07 am

Dear Friend,
This convertion format is very useful to me I used excel since 1996 onwards and I asked to convert the figure to write in indian currency format, so they advised me there is no way in excel but I found out that suresh Add-in is very useful for me and also for the user of excel
Thank u lot for Suresh-addin

18 shah hiten December 24, 2008 at 4:24 pm

Its a really nice and very useful addin you develop thank you very much for your web cooperation

19 Mohamed Habibullah December 31, 2008 at 2:19 pm

Really very use for me. And also kindly suggest to remove the “Rs.” Prefix. Thanks

20 Albert DLima January 25, 2009 at 9:14 am

Hi Suresh

Great Job. Keep up the good work !!

21 sadanand January 25, 2009 at 12:25 pm

I express my happines about work. I have downloaded and added in Ad-Ins. But when i enter formula i have received message like “compli error in hidden module; numbertofigure”.
Kindly guide me

22 IG January 26, 2009 at 1:09 am

Brother, kindly mail me the editable version of your code. Your addin is really helpful, i need to print the words on cheque leaf where ‘rupees’ word is already mentioned, so need the code without the ‘rupees’ tag. it will be great if you mail me the same. Take care and keep creating useful things… CHEERS

23 sadanand January 26, 2009 at 4:52 pm

Dear Sir, I appreciate your good efforts in this direction. It works on ms office-2003 but does not work in office-07. Will you gide me in this regard.

24 Umesh Kanchan January 27, 2009 at 2:47 pm

thank you sureshbhai………….

this is really very helpful

excellent job. thanx once again…………..

25 Raju January 28, 2009 at 12:01 pm

Hi Mr Suresh,

Its a wonderful add-in. your work is highly appreciated. If any new tips on excel please send to my mail Id. kesetti_raju@rediffmail.com

Thanks

26 Sanjay Kumar February 2, 2009 at 3:04 pm

Hi Suresh

Currently i m working on Excel 2007 i want to convert number into indian rupees i’ve installed the addin but it’s not working

Thanks in Advance
sanjay1190@gmail.com

27 pradeep February 5, 2009 at 7:54 pm

it a great solution.

28 Arun February 13, 2009 at 3:44 pm

Thank you..Thesefunctions are helping a lot.

29 Pat Bates February 21, 2009 at 11:56 pm

Hi Suresh, Thank you for writing the rupee functions & easy to follow instructions. I wanted to look at your INR() function so I could use it as my base… I need a routine with the commas for lakhs and crores, but I don’t want the rupees symbol or any digits after the decimal place. I couldn’t open SureshAddIn in excel because I don’t have the password. Would you please send it to me or assist me in writing a function. Thank you so much, Pat

30 Shazil February 24, 2009 at 2:29 pm

Hi, Suresh,

What can i say, i have no words to thank u for the excellent and splendid job u did. it is very useful for me , i pray to God to give u more talent.

Request: can i change lakh(s) to lac or lacs and
i need to print the words on cheque leaf where ‘rupees’ word is already mentioned, so need the code without the ‘rupees’ tag. it will be great if you mail me the same. Thanks a lot.

31 Ashish Soni February 25, 2009 at 4:00 pm

Thanks Suresh,
Its been a long time I had been searching for such a utility.

32 lalit February 28, 2009 at 3:18 pm

Hi, Suresh,

This is very excellent work i have no i have no words to thank u for this work. it is very useful for me , Request: can i change lakh(s) to lac or lacs and
i need to print the words on cheque leaf where ‘rupees’ word is already mentioned, so need the code without the ‘rupees’ tag. it will be great if you mail me the same. Thanks a lot.

33 gaurav March 17, 2009 at 11:15 am

Hi Suresh,
it’s a very usefull tool. thank you. i give this tool to my friends and they also found it very usefull. thanks again.

34 Magesh March 24, 2009 at 1:23 pm

It is an excellent job. It works with Excel 2007. But you could have added few more digits like up to 1000 coroes. I am not a techie. I may not understand VB. But I can do good formulas in excel. Can you suggest me some way to convert upto atleast 999 crores to word.

35 pradeep April 10, 2009 at 2:33 pm

Thankyou Mr. Suresh, Its really useful, may i have a request can you tell me how to put seperators (i.e. commas ) in Indian system of accounting without having Rs.added to it. I have been searchig for this but i couldnt find.

Also help me in cell content blinking on errors or any spl case

with regards

pradeep

36 shiv April 13, 2009 at 2:08 pm

very advantageous to certain limit.

The addin will not work if the rupees is more than crores.I mean if it is in billions.

And same with =rswords also.

37 Rakesh April 23, 2009 at 7:07 pm

Very Useful . Thanks

38 Antony May 16, 2009 at 11:20 am

Hi, Suresh, you have done a great job, wounderful and very useful too. In the Add-in, rswords(), is there any option not to print “Rupees” in the begining. Would you please help me?

39 Mano June 2, 2009 at 2:46 am

Thank you very much for your effort

40 Manoj KMG June 3, 2009 at 11:26 am

Your work’s excellent, thanks. Could you make such a conversion for ms access?

41 anurag gupta June 5, 2009 at 9:41 am

Hi Suresh

Gr8 job done ! i was looking 4 this from some time now..

Request you to please share other excel stuff specially related to Dashboards etc…

Thanks a lot once again !!!!!!!!

42 Mohammed Ibrahim June 6, 2009 at 2:35 am

Hi Suresh U done very well job its obslotely very fantastic
I have so many works in excel its really very useful for me thanks a lot

43 Dheeraj Madaan June 6, 2009 at 4:15 am

Dear Suresh,

I wanted the formula to convert number into text , I got to know abt the site and found out what I required the formula of addis. Its very good that you are helping people by providing it on the web page

Thanks & Regards
Dheeraj Madaan

44 Bharat Patel June 11, 2009 at 12:11 am