Number to Words in Excel - Another Method

Recently one of my visitor ask me about my previous post of convert number to excel in word is not working in his excel sheet. I am again check my link sheet for working properly or not. Its working but viewers did not add it in Excel Add-in & have problem to convert number into words (or Rupees INR). So now i put another method to convert number into words. Perhaps its working better than my previous method & easy to install in Excel File. Tally Knowledge team is convert this function script for specially our indian viewers. But this script working with any currency & in any country code. For indian users, by using this script you can convert number to indian rupees also. Let we do it with some very easy steps.

Download the script file from click Here!

Open your excel sheet & press ALT+F11, it start your excel visual editor.

Click on Insert Menu & Module.

A new window will appear in your visual editor, paste this script file code in this new window. Press Ctrl+S to save your file.

Now put numerical value in any cell of your ms excel worksheet (suppose you enter amount in cell no. A2, in another cell enter this formula =spellnumber(A2) you must give reference of that particular cell which you want to show in words. See below image.

Its all done. This function is work for only single particular sheet, if you want to work this method on your all sheet then you must re-install your msoffice application & when you open your 1st Excel sheet put this method again & save as your excel sheet as macro workbook sheet, after do these steps this function is work with your all excel worksheets.

How to convert Amount to Words in Excel

Some time we need to change a numeric amount to words i.e. Rs. 4500 in words Rs. Four Thousand Five Hundred. We do this with a very simple add-in installation to our excel worksheet. This add-in has 3 amazing functions called = INR() (Indian Rupees Initial (Rs.),  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().

INR () function convert the whole number include sign of Rs. with the amount. (See following pic).

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 following image.

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 this AddIns?

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 AddIns.xla and then click OK. You have installed the AddIn.

How to use AddIns?

You can use this AddIns 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 AddIns.

Click here to Download this Add ins