CONVERT FIGURES IN TO WORD EXCEL ADD IN INDIAN RUPEE

SHARE:

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.
Load or unload an Excel add-in program
  1. Click the Microsoft Office Button Button image, 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.

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 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  
[lock]
Download SureshAddIn
[/lock]
if you do not have facebook or Twitter account then to download the addin visit page-2
[next]
Download SureshAddIn

COMMENTS

BLOGGER: 94
Loading...
Get Latest Updates In your Inbox

$show=index

Name

. SECURITIES (MNP) (TDS)2007-08 ` 01.07.12 01.09.2008 01.10.2012 06.07.2009 07.08.2012 1 PERCENT EXCISE ITEMS LIST 1 sep 1% excise 10 year nsc 10(10C) 1000 court cases judgements supplied to ITO 1000 rupee note 11-2008 11-2010 130 items 14.08.2008 15 august 150 Rs coin 15g 15h 18-12-2009 192(1A) 192A 194 I 194A 194c from 01.10.2009 194H 194j 194LC 1981-2007 2% cst 2% excise 2004 2008 2008-09 FY 2010 206AA 234A 234B 234C 234c interest calculator 234E 23AC 23ACA 23B 24C 24q annexure II 25 paisa coin 271(1)(c) 271B 271H 272B 27A 280 280 challan 281 282 283 29 AUGUST 29.04.2010. 29/08/2008 29/2008 service tax 2g meaning use 3 idiots 30 MARCH 31st March 32-2010 33 of 2009 35(2AA) 35(2AB) 3CD 3g meaning use 40(b) 43B 44 AB EXEMPTED INCOME 44AA 44AB AGRICULTURE 44AB new limit 44AB NON RESIDENT 44ad 46/2012 45/2012 49C 5 day week 5 years post office deposit 5/2011 50 paisa coin 54b 54EC 54ee 54f 54gb 5th paycommission punjab 6 % excise 6 crore advance limit 6/2005 69/2010 6th cpc 6TH PAY COMMISSION 70% of pan etds 7th Central Pay Commission 8 tips to save tax 80C 80ccc 80CCD 80cce 80CCF 80CCG 80d 80DDB 80EE 80G 80GG 80GGA 80GGB 80ggc 80tta 80U 85% of pan etds 86/2008 DATED 13-08-2008 87A rebate 89(1) 89(1) relief calculator 9.5 % rate for private epf 92E 95% of pan etds 98 dated 04/01/08 aadhaar aakash tablet aam admi aar Aayakar Sampark Kendra abatement abolished ACCOUNT PAYEE DRAFT Accounting ACCOUNTING CODE accounting code for services ACCOUNTING FOR GOVT GRANTS accounting standards ACES ADD IN Add-Ins additional relief in budget 2010 adjustment of advance FBT with advance Tax advance rullings advance salary ADVANCE TAX CALCULATOR advance tax challan ADVANCE TAX CUT OFF AMOUNT ADVANCE TAX DATES AFFIDAVIT AG Projects Technologies Ltd RT age 80 addition pension aibea wage revision aibea wage revision latest news aiboa aiboc aiboc wage revision AIG AIR airline ticket booking tds airlines all is well allowances allownces alphabet of inspiration alteration on check allowed alternate minimum tax AMENDED 3CD amendment in companies bill 2011 amendment in gratuity act 2010 amendment in registration service tax AMENDMENT IN SERVICE TAX ON RENT amendment to finance Bill 2010 AMNESTY SCHEME 2007 amt Anna Hazare anna hazzare bill vs govt lokpal bill appeal apply for new pan card against old pan card aqb arbitration arrears of salary arrears of sixth pay ARRERS TAX AS-12 ASBA assessee in default ASSESSMENT REOPENING ASSESSMENT YEAR 2008-09 REFUND atm atm 100 per day atm cash without card atm tips atm wrong debit audit cases itr filing audit limit enhanced Audit Questionaire AUDIT REPORT AUS VS IND.INDIA VS SL Automated teller machine AUTOMATION OF CENTRAL EXCISE AND SERVICE TAX ay 2010-11 bad debts