Convert an Amount from Numerics to Word (Indian Rupees) in Excel 2010

"NumtoRupees" Indian Rupees Function is an Excel function manually created with VBA code to change a given Amount to written words in Indian Rupees along with paise. In other  words it converts "₹" in to "INR".

This function is not a inbuilt function to display the numeric value in words.

So we are going to create this function. 

First of all you have to click on this LINK this will open a new tab containing a file see in picture below.

1. Click on file and Press Ctrl+A (select all) and Copy All by pressing Ctrl+C.

2. Go to Desktop -----> Right Click on Desktop -----> New -----> Microsoft Excel Worksheet. (See in Picture below)

See there is a file on Desktop, Give a Name to this file and open it.

3. After open this file press Alt+F11 for open VB File window and go to Insert ---->Module.

4. In this next Module code file Paste code by pressing Ctrl+V.

5. After doing step no. 4 press Ctrl+S for save Module.

This is will be save as a Macro enabled workbook so click on YES for continue. (See Picture Below)

6. Save excel file. and Click on OK.

Congratulations !!

Your File is ready to use..

Ok Let's use this file with in example.

--> Create a column containing some numbers from B3 to B24.

--> use formula in cell C3 =NumtoRupees(B3).

And Press ENTER.

See the formula is working. 👇

Thanks for Learn with me.