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 Suresh Add Ins?

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 through the Insert>Function menu. In the category drop down box choose User defined and you will see the above three functions of SureshAddIns.

For Excel 2003 and earlier versions
To install an addin for Excel install addin from Excel's manual Tool->Addin... then browse.

Do not change the Place of File after installation.Further If you want to share excel files with other persons where this addin has been used then convert all the cell where addin used with special paste as value otherwise error will be shown in other computer where addin has not been installed

1. Click the Microsoft Office Button , and then click Excel Options.
1. Click the Add-Ins category.
2. In the Manage box, click Excel Add-ins, and then click Go.
3. To load an Excel add-in, do the following:
1. In the Add-Ins available box, select the check box next to the add-in that you want to load, and then click OK.
1. If the add-in is not currently installed on your computer, click Yes to install it.
TIP   Follow the setup instructions as needed.
1. To unload an Excel add-in, do the following:
1. In the Add-Ins available box, clear the check box next to the add-in that you want to unload, and then click OK.
2. To remove the add-in from the Office Fluent Ribbon, restart Excel.
NOTE   Unloading or removing an add-in from the Ribbon does not delete the add-in from your computer. To delete the add-in from your computer, you must uninstall it.

BLOGGER: 106
1. Truly it is very useful for excel user in india.Thanks a lot to Creator.

Thanks,
Harendra Kumar
Pune, India.

1. But this is not working in MS Office 2010.
Ambareesh

2. Hi, Thanks.
User can also try free GWORD addin formula which auto convert numbers or amount to words or rupees.

2. Sir,

This function is good but one problem is rise i.e. if I add Rs. in figure than other link columns & row found error i.e. they do not calculate total, percantage or etc.

1. If u want to use Rs. or new rupees symbol then first download "Rupees Foradian" and install it in the Font. Then in excel you choose your number by selecting the column then open format cell and then click on the currency button and use symbol none and separate ",". Now you choose custom menu and in the custom menu you type on the begin
"` " along with other text. After than you choose all the column font as Rupees Foradian.

If you what old "Rs." then you simply choose select column then format cell and then currency and separate"," . Now you choose custom menu and in the custome menu you type on the begin "Rs. " along with other text.

You use all the formula and it doesn't arise any error.

3. dear HArdbdra,
amount in figures and words are normally used in separate cell. so for calculation use amount in figure

4. great work... thanks a lot....... Keep up....

5. thanks it is Truly very useful for excel user in india.Thanks a lot to Creator.

India

6. Thanks !
satish_asian2000@yahoo.com

1. here is the link

2. I tried the link:

But got the message:

Firefox can't find the server at www.dq.winsila.com.

Kindly suggest. Thanks. RAKESH

3. Link is given on page -2

4. do well something is missing

8. thanks a lot...... super like

9. Dear sir it will not give the result in words if the figures are in negative. please do the same in negative case and give updated version of this.

thanks

kalpesh shah
9890208175 / 8767131113
kalpeshyshah@rediffmail.com

10. Sir, Please change Rs. sign to New Indian Rupee symbol when wirting in words

11. Hey........ friend this is not working in excel 2007.Please give me the function which can convert the currency in INR in excel 2007, pleeeeeese.

1. It is also working in Microsoft excel 2007 ,Kindly follow the instruction given above Sr no 1-5 carefully

2. It will work, simply change its extension from .xls to .xla

vnsukla@yahoo.com

12. Its a fantastic....

13. Finally its done.. Thanks for the link, great job! Keep it up

14. Great.......its a very usful thanks a lot

1. What is Service Tax Rate to Service Receiver (if Service Receiver is a Company) on Rent a Cab service received from Service provider (if service provider is a Proprietorship firm)

15. I am having two properties, one is self occupied, and other is let out.
my annual income is below 5 lacs, and interest from saving is also below Rs. 10,000.
I have availed home loan on both the houses, and want to claim interest and principal paid.
1) whether I have to file return for f.y. 2011-12 and a.y 2012-13.
2) if yes, which return Itr-1 or itr-2
3) where to claim lossess of house property
4) is it in sr. no. 6 of part-B of TI computation of Income of ITR-2.
and sch-CYLA by deducting the loss from salary.
5) where to claim principal paid for emi for the year.

1. Point wise answer is given below.

1.You have to file return for Fy 2011-12
2.ITR-2
3.You have to fill sch HP house property read how to fill here
http://www.simpletaxindia.net/2012/07/house-property-income-tax-return-filing.html
4. Fill ITR form in excel sheet figure will be filled automatically
5. principal is covered u/s 80C sch VIA in itr-2

2. thanks for quick reply.

16. This comment has been removed by the author.

17. Hi suresh,

i dont want to show the paise thing in the figures ,i just want round of figures
how is is possible?

1. here is a small macro. Just paste it and use it:
Public Function f2w(num As Long) As String
Dim intpart As Long, decpart As Integer, park As Integer, zastring As String
zastring = ""
intpart = num
If intpart = 0 Then
zastring = "Rupees nil "
ElseIf intpart < 2 Then
zastring = "Rupee "
Else
zastring = "Rupees "
End If
park = Fix(intpart / 10000000)
zastring = zastring & getword(park, "crore ")
intpart = intpart Mod 10000000
park = Fix(intpart / 100000)
zastring = zastring & getword(park, "lakh ")
intpart = intpart Mod 100000
park = Fix(intpart / 1000)
zastring = zastring & getword(park, "thousand ")
intpart = intpart Mod 1000
park = Fix(intpart / 100)
zastring = zastring & getword(park, "hundred ")
park = intpart Mod 100
zastring = zastring & getword(park, " only")
f2w = zastring
End Function
Function getword(t3 As Integer, plas As String) As String
If t3 = 0 Then
getword = ""
ElseIf t3 < 20 Then
getword = retteen(t3) & " " & plas
Else
getword = retten(Fix(t3 / 10)) & " " & retteen(t3 Mod 10) & plas
End If
End Function
Function retteen(t2 As Integer)
Dim teenstr As String
teenstr = "one two three four five six seven eight nine ten eleven twelve thirteen fourteen fifteen sixteen seventeeneighteen nineteen "
If t2 = 0 Then
retteen = ""
Else
retteen = Trim(Mid(teenstr, (((t2 - 1) * 9) + 1), 9))
End If
End Function
Function retten(t1 As Integer)
Dim tenstr As String
tenstr = "twenty thirty forty fifty sixty seventyeighty ninety "
retten = Trim(Mid(tenstr, (((t1 - 2) * 7) + 1), 7))
End Function

2. Please tell how to use this

18. Great Boss. !!!!

19. Thanks a lot. It is very helpful

20. THIS HELPS ME TO WRITE NUMBER INTO WORD FORMAT I AM VERY THANK FUL TO YOU

21. very nice to see this feature simplified as add ins Thanks a lot...keep post something useful to every one aware of it.

22. Thanks A Zillion Mr. Suresh

- Nikhil Neelakant

23. Working Fine Thanks alot

24. Thank you, it is very useful.

25. Dear Sir,
Is it possible to remove "Rs" from starting so that value can be taken as " 300,000.00" if yes plz let me know at

26. I AM NOT ABLE TO USE.....
I HAVE EXCEL 2010

27. sir

when i transfered this file to another pc where this addin is not installed then this is not running

1. it is already being mentioned in limitation given above. However in 2007 and above you can save file with macro's which is saved with ext. xlsm .if you save file with macro then it will work in other computer also.

28. Dear Sir,
The function to covert courtesy amount (in figures) to legal amount (in words) is indeed good work.
However, for formatting of amount in figures as per indian practice of lacks and crores is simply provided in OS itself since Windows 98. Go to Control Panel, Regional & Language Options and there customize the numbering formats (under number groupings) which is self explanatory. This is one time step and then no need to covert or re-convert, and it affects display of all the files.
Regards,
Manoj Agarwal - 9937041788

29. Dear sir,

Rohit

30. cool................ very very nice

31. Very good,

Kindly give the suggestion to remove Rupees text from words

32. hello all,
it will open a new page with the zunk character.

1. but its working well when we have click ,so pls provide your mail address

2. im using firefox, thats why face the problem, i tried using chrome and IE, both working fine. thnx for such a nice add-on. :)

33. Hey This is Amazing is this feature also available in MS Word ? what am I supposed to do if I want this to work in MS Word ?

Thanks

34. Thank you, it is very useful.

35. Thank you ...its great and very useful..

36. Thanks a Lot... It is Very Helpful...............

37. great work... thanks a lot....... Keep up.... Please prepare Under rupees -------------------------- only ) by enhancing on number. It will be used to place protective words in preparing bills

38. Zillion Thanks ....

39. Thanks a lot!

40. very helpfull.....many many thanks....but ask u again same q....remove "Rs" from starting...?? i need only words ....please help

41. very helpfull.....many many thanks....but ask u again same q....remove "Rs" from starting...?? i need only words ....please help

42. very helpful... thanks a lot...

43. after instulation,how to use this formula

44. Very very usefull and helpfull please keep it

Ramesh, Attur

45. Dear Sir,
Its nice and useful function for us. Thanks a lot for this. I also requested you to please add New Symbol for Rs. in that function and also in words some changes like : 50.56 (Rupees Fifty and Paise Fifty Six only) is may kindly be corrected as (Rupees Fifty and Fifty Six Paise only).

I also requested you to please give me add-in for date to words function like : 29-12-2013 (Twenty Nine December Two Thousand Thirteen).
my Email ID- bapibiru@gmail.com

Frankly I also pay the requisite amount if it not free.

Thanking you.

J.K. Satapathy

46. Thanks.
Also we can Try this Excel Add-in - CLICK
http://www.xl.nikash.in/2012/06/convert-number-to-english-indian-rupees_8693.html

47. Dear
Thanks for your add ins this great, work great
thanks
thanks once again
Raj

48. Thanks sir,
very useful and important addins which are provided by you
Thanks lot again
How we get the new addins or excel creations of your?

49. I have added Suresh Add Ins on a file that is shared on a server. It is not a shared work book, just located on a server where more that one computer/user has access to it. However the formula does not seem to work when opened on the shared computers unless I again go in to each location of the equaction rswords() and type it in again. Why is this?

50. I am using suresh ad ins for the rswords(). equation. I have it in stalled on a workbook that is saved on a server. However when I access the same work book on another computer that is on the server, the equation dosent work. It shows the path as ='\\Server\logos letterhead\SureshAddin.xla'!RSWORDS(E24). I have to each time then go to that users computer and re enter the equation as rswords() in each cell that it is required to be used in. How to I avoid this problem?

51. Thanks a lot.Its been lot of help.
Hari Mohan

52. Thanks,

It's vary useful one.
Sir, I am using OPENOFFICE, is there such add in for open office too ?
If it is please let me know how can I download and install it?
Once again thanks.

Dinesh Parmar

53. link not work plz do the needful...

54. Thanks dear, it was very useful. Keep it up.

55. Thank you sir. it is very very useful for me and something newly learned

56. Very very Useful. Good work.

57. Sir, it is very good Add-in .. thank you for providing the same.

58. This is really helpful. Thanks a lot.

59. Hi Guys,

This is the well defined and customized micros program for Indian Rupee Value:

Function 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

1. where do i paste this code in computer
i tried in visual basic but not worked. i want to know where is the actual position for copy this code.please help

2. if we have to convert the amount more than crore then it does not work hence how can we convert the amount more than crore

60. great work... thanks a lot....... Keep up....

61. Thanks for the Add-in. I have a question. Is there any option to insert Rupee Symbol for Rs.

62. this Add-in is good. Could we use it MS Word?

63. i have not got the answer whether I could use this ADD-IN in MS WORD

1. No ,you can not use this in MS word

64. Can you add Rupee Symbol ???? in this formulae

65. link not working

1. Link is given on page -2 or click facebook like or tweet

66. Great job! Very useful :)

67. Hi,

It is an awesome addin. I however want to know why lakhs is being shown as lakh(s)

68. Hi,

It is an awesome addin. I however want to know why lakhs is being shown as lakh(s)

69. Pls send me the file sureshadd over my email: rajesh061981@gmail.com as I am unable to download from your site. I'll be very thankful to you.

70. Pls send me the file sureshadd over my email: deepak2659@@gmail.com as I am unable to download from your site. I'll be very thankful to you.

71. Pls send me the file sureshadd in over my email: sumitguha1978@gmail.com
as I am unable to download from your site. I'll be very thankful to you.

72. paise comes after last "and". Paise should come befor "only".

73. Great Job....Thanks a Lot.....

74. the function REVINR(xx) IS WORKING IN EXCEL 365?? pLS HELP

75. any sortcut key available this formula

76. i want figure word in bracke ( Rs.................... Only)

77. Pls send me the file sureshadd over my email: kudekarpranav01@gmail.com as I am unable to download from your site. I'll be very thankful to you.

78. If we close the excel and then again restart after some time, then this add in is not working . Can you help on this ? It is functioning as long as I am using excel. Once i close the excel and after some time starts working again, then add in is not functioning. Plz support

No spam allowed ,please do not waste your time by posting unnecessary comment Like ads of other site etc.

Name

ltr
item
SIMPLE TAX INDIA: CONVERT FIGURES IN TO WORD EXCEL ADD IN INDIAN RUPEE
CONVERT FIGURES IN TO WORD EXCEL ADD IN INDIAN RUPEE