CONVERT FIGURES IN TO WORD EXCEL ADD IN INDIAN RUPEE

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 figur...

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 add-in for Excel install the add-in from Excel's manual Tool->Addin... then browse.

Do not change the Place of the File after installation. Further, If you want to share excel files with other persons where this add-in has been used then convert all the cells where the add-in is used with a special paste as value otherwise an error will be shown in other computers where the add-in has not been installed  

[post_ads_2]

This is premium content share this post on Facebook and twitter and then the lock will be opened. Otherwise, visit page 2 for the direct download Link.

Also Read [Excel Tips-1] 

[lock]

[Download SureshAddIn##download##] [Read More Post On Excel Tips ##eye##]
[/lock]

Load or unload an Excel add-in program

1. Click the Microsoft Office Button , and then click Excel Options.

2. Click the Add-Ins category.
3. In the Manage box, click Excel Add-ins, and then click Go. 
4. 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.

2. If the add-in is not currently installed on your computer, click Yes to install it.

 TIP   Follow the setup instructions as needed.

5. 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.

If you do not have Facebook or Twitter account then to download the add-in visit page-2

[next]

Tags:suresh addin , suresh addins , suresh addin download ,sureshaddin ,sureshaddin download ,suresh addin for excel ,sureshaddin.xla ,rupee symbol text, spell number in excel in rupees add-ins ,rswords formula in excel, 

This blog post discusses an Excel add-in called SureshAddIns that converts figures into the Indian Rupee format, as well as displays the amount in words. The add-in includes three functions: INR(), REVINR(), and RSWORDS(). The INR() function converts a number to the Indian style comma-formatted currency, while the REVINR() function converts the result obtained from the INR function back to a number format for calculations. The RSWORDS() function converts any number to currency in the form of words.

The post goes on to explain how to install the add-in and how to use it in Excel. It also provides instructions for Excel 2003 and earlier versions, and notes that if the add-in is used in an Excel sheet, the sheet should be converted to "values" before sharing with others to avoid errors on computers without the add-in installed.

The post also includes an instruction on how to load or unload an Excel add-in program via the Excel Options > Add-Ins category and Manage box.

The post concludes by saying that the add-in is premium content and can be downloaded by sharing the post on Facebook and Twitter, or by visiting page 2 for the direct download link.

[Download SureshAddIn##download##] [Read More Post On Excel Tips ##eye##]