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
DEAR SURESH,
YOU SHOWED SUCH A EXCELENT WAY IN EXCEL THANK YOU MY DEAR FRIEND……
REGARDS,
D.MURUGANAND
98650 39915
EXCELLENT
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
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,
its really a good software
Good work in Excel.
Dear Suresh,
Thanks a lot. This is what I was looking for for the
last two years.It works very good.
K.Elango
Suresh, very good and useful addin, it’s just what I was looking for ….. thanks a ton.
A+
Thank you.
GR8 job done, do posting such helpfull material whenever available, this will help users like me or with intermediate knowledge.
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
very very neat addin…useful almost everyday in my small business invoice printing. keep up the good work.
S
Dear Suresh,
Thank U very much.You did a great job.
Regards,
Girish
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
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
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.
@Prem Kumar: Thank you very much for pointing out the error. I have corrected it now.
Excellent!!! Super Stuff !!!
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.
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.
Great tool, Hats off to Suresh. Thank you very much.
Hi, It is really useful and very good piece of work.
hi suresh …
i want to serch options while using if condition…. any micro script is there ….
@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?
Hello Mr Sureshji
Really it is very usefull development.Thank you for this.
DIGESH SHUKLA
ASST LIBRARIAN
MGSIRD, JABALPUR MP
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
Sir,
Pls advise is there any option to show INR without showing Rs.
Regards,
Avadhani.
Dear Mr.Suresh,
Thank you very much for Excel AddIn to show Currency in Indian format and Words it is very useful.
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
Lots of Thanks suresh
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
gr8 yaar… u have solved my problem.
Thanks, what a nice addin. It reducess our work very much. Thanks a lot again.
It solved my Problem-Thanks a Lot
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.
I want the figure Lac instead of Lack(s)
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,
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
Thanks Suresh!
If you possible please post the source code of this useful add-in.
send me SureshAddins
very good
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
Hi
It’s Asking For Password Can You Please Let Me Know What Is The Password
Hi
It’s Really Fantastic
Thank You So Much
Thanks Again
Sanjay…
Dear Suresh, Thanks a lot for a very simple way to convert numbers into indian currency (both in figures and words).
My question is, can we also convert the numbers into USD (both in figures and words). If yes, please shows the method.
with best regards,
ABDUL HAMED
DEAR SURESH, IT IS VERY GOOD AND EASY TO ACCESS OPTION. DO U KNOW SOME OTHERS INTERESTING THINGS, IF YES, PLEASE SHOW US
THANKS
ABDUL HAMED
Hats off to you Suresh. So many people will benefit from this formula. Thanks a lot and GOD Bless you. Will you please let me know how to understand and learn different formulas to use in Excell. If there is any Formula modular lessons please let me have it. Thanks a lot
I don’t know if its happening only with me or the AddIn doesn’t works out.I am using MS Office XP.Is’s show some error.
what I mean to say is it doesn’t calculate the numbers in that format.
Hai, Despiratly i want that ADDin,
Where Can i download it.
I want to know if the currency has 3 decimal places like 123 Bzs, will it still work.
← Previous Comments
{ 6 trackbacks }