SpellNumber Indian Rupees Function is an Excel function manually created with VBA code to change a given number to written words in Indian Rupees. In other words, it converts a numeric value of INR to words along with paise.
Microsoft Excel does not have an inbuilt function to display the numeric value in words. As many and many users demanded Microsoft has provided the SpellNumber VBA code.
It can be inserted into your Excel workbook. This function spells the numeric value to words as the name suggests.
In simple terms, to display $ 2,345.50 as “Dollar Two Thousand Three Hundred Forty-Five and Fifty Cents”, you can use the SpellNumber Function.
Whereas, to display INR 2,345.50 as ” Two Thousand Three Hundred Forty-Five Rupees and Fifty Paise ” using the SpellNumber Indian Rupees Function.
We have edited the same code with some changes for the required result.
In this article, we will discuss the whole step by step process on how to create this SpellNumber Function for Indian Rupees using the VBA.
You can also check our SpellNumber Without Currency and SpellNumber for UAE Dirhams.
How To Create SpellNumber Indian Rupees Function
Step 1: Open a new workbook.
Step 2: In the Top Ribbon, Go To Developer Tab.
Step 3: Click on “Visual Basic” in Code.
Step 4: Click on “Module” under the Insert menu as shown below:
A blank module sheet will open.
Step 4: Copy the below code and paste it into this Module sheet.
Code for SpellNumber Function for INR
Step 5: Click the “Save” button or press Ctrl+S. The screen will display a dialog box as shown below.
Your file now consists of a macro thus you need to click the “No” option.
Step 6: Select “Save As”.
Select the desired location where you want to save this file and select the “Save as type” as an “Excel macro-enabled workbook”.
SpellNumber function for INR (Indian Rupees) is now created and saved in your workbook.
Using SpellNumber Indian Function
Let us try the above code which we created in our workbook.
Insert number in column A. In column B insert the formula: = SpellNumber(A1). Use the fill handle function to copy the formula in all rows.
It will display the word Indian rupees format as shown below:
Note: Please keep in mind that this function will only be available in this workbook. Follow the above spets to get this function in another workbook.
Please keep in mind that every time you open this workbook or any other macro-enabled workbook you will get a security warning below the ribbon. See image below:
Select “Enable this content” and click on “OK”. Otherwise, the code will not function.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries or suggestions please share in the comment section below. I will be more than happy to assist you.
AFTER CLOSE THE EXCEL SPELL NUMBER FORMULA COULD NOT RUN
You need to save the file as a macro-enabled file. The spell number is specific for the file you add. It will not work in another file unless you do add the code in the new file and save it as a macro-enabled file.
can we save permanently in Ms Excel When we open any file then no need to add this code again and again
No, you cannot save this permanently in excel. You need to enter the code in each file you want.
No Rupees and Ten Paise
One Rupee and No Paise
Ten Rupees and No Paise
One Hundred Rupees and No Paise
One Thousand Rupees and No Paise
Ten Thousand Rupees and No Paise
One Lacs Rupees and No Paise
Ten Lacs Rupees and No Paise
One Crores Rupees and No Paise
Ten Crores Rupees and No Paise
One Hundred Crores Rupees and No Paise
———————————————————————— (no confusion)
Ten Hundred Crores Rupees and No Paise
(can u mention it as thousand crores)
————————————————————————
further , can u add this , since it is not there , if we have to do gdp figure analysis , it is needed.
ten thousand crore
lakh crore
ten lakh crore
hunderd lakh crores
thanks in advance
An email has been sent to your email address related to your query.
instead of :- Ten Hundred Crores Rupees and No Paise
can u mention it as:- thousand crores Rupees and No Paise
————————————————————————
for the below mentioned values , there are no information ,
can you please create them :-
1) ten thousand crors Rupees and No Paise
2) lakh crores Rupees and No Paise
3) ten lakh crores Rupees and No Paise
4) hunderd lakh crores Rupees and No Paise
thanks in advance
Dear Shankar, Already sent an email on shankarsetty@yahoo.com
Sir, I donot want the “No paise” to be displayed. What should be done to get absolute value alone.
Thanks in advance
regards
You can remove it from the code and it will not display the No paise.
Formula to convert indian currency upto 10 digit:
=IF(D71,CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),3,1)+1,””,”-one”,”-two”,”-three”,”-four”,”-five”,”-six”,”-seven”,”-eight”,”-nine”),IF(VALUE(MID(TEXT(INT(D7),REPT(0,10)),2,1))=0,CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),3,1)+1,””,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”),””)),IF(D7>=10^8,” corer “,””),CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),4,1)+1,””,CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),5,1)+1,”ten”,”eleven”,”twelve”,”thirteen”,”fourteen”,”fifteen”,”sixteen”,”seventeen”,”eighteen”,”nineteen”),”twenty”,”thirty”,”forty”,”fifty”,”sixty”,”seventy”,”eighty”,”ninety”),IF(VALUE(MID(TEXT(INT(D7),REPT(0,10)),4,1))>1,CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),5,1)+1,””,”-one”,”-two”,”-three”,”-four”,”-five”,”-six”,”-seven”,”-eight”,”-nine”),IF(VALUE(MID(TEXT(INT(D7),REPT(0,10)),4,1))=0,CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),5,1)+1,””,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”),””)),IF(VALUE(MID(TEXT(INT(D7),REPT(0,10)),3,3))>0,” lakh “,””),CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),6,1)+1,””,CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),7,1)+1,”ten”,”eleven”,”twelve”,”thirteen”,”fourteen”,”fifteen”,”sixteen”,”seventeen”,”eighteen”,”nineteen”),”twenty”,”thirty”,”forty”,”fifty”,”sixty”,”seventy”,”eighty”,”ninety”),IF(VALUE(MID(TEXT(INT(D7),REPT(0,10)),6,1))>1,CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),7,1)+1,””,”-one”,”-two”,”-three”,”-four”,”-five”,”-six”,”-seven”,”-eight”,”-nine”),IF(VALUE(MID(TEXT(INT(D7),REPT(0,10)),6,1))=0,CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),7,1)+1,””,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”),””)),IF(VALUE(MID(TEXT(INT(D7),REPT(0,10)),5,3)),” thousand “,””),CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),8,1)+1,””,”one hundred “,”two hundred “,”three hundred “,”four hundred “,”five hundred “,”six hundred “,”seven hundred “,”eight hundred “,”nine hundred “),CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),9,1)+1,””,CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),10,1)+1,”ten”,”eleven”,”twelve”,”thirteen”,”fourteen”,”fifteen”,”sixteen”,”seventeen”,”eighteen”,”nineteen”),”twenty”,”thirty”,”forty”,”fifty”,”sixty”,”seventy”,”eighty”,”ninety”),IF(VALUE(MID(TEXT(INT(D7),REPT(0,10)),9,1))>1,CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),10,1)+1,””,”-one”,”-two”,”-three”,”-four”,”-five”,”-six”,”-seven”,”-eight”,”-nine”),IF(VALUE(MID(TEXT(INT(D7),REPT(0,10)),9,1))=0,CHOOSE(MID(TEXT(INT(D7),REPT(0,10)),10,1)+1,””,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”),””))),” “,” “)&IF(FLOOR(D7,1)>1,” rupees”,” “)&IF(AND(D7>=1,D7<2),"rupee",""))&IFERROR(IF(D71,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(D7,”.”,REPT(” “,255)),255,200)),2)),REPT(0,10)),10,1)+1,””,”-one”,”-two”,”-three”,”-four”,”-five”,”-six”,”-seven”,”-eight”,”-nine”)&” paisa”,IF(LEFT(TRIM(MID(SUBSTITUTE(D7,”.”,REPT(” “,255)),255,200)),2)=”01″,”one paisa”,IF(LEFT(TRIM(MID(SUBSTITUTE(D7,”.”,REPT(” “,255)),255,200)),1)=”0″,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE(D7,”.”,REPT(” “,255)),255,200)),2)),REPT(0,10)),10,1)+1,””,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”)&” paisa”,””))))),””)))