A copy-paste Excel formula and VBA function for rupees in words
Runs in your browser. Nothing you type is sent anywhere. Checked against sources on 29 Sept 2026.Checked against the tool’s code on 18 November 2026. Figures read from their sources on 29 September 2026. What we collect
To write an amount in words in Excel, paste the formula on this page into B2 with the amount in A2: for 1,25,000.50 it returns Rupees One Lakh Twenty Five Thousand and Fifty Paise Only. It needs no macro in Excel 365 and Google Sheets; older Excel gets a VBA function.
| In A2 | The cell shows |
|---|---|
| 0.75 | Rupees Zero and Seventy Five Paise Only |
| 999 | Rupees Nine Hundred Ninety Nine Only |
| 45,000 | Rupees Forty Five Thousand Only |
| 1,25,000.5 | Rupees One Lakh Twenty Five Thousand and Fifty Paise Only |
| 10,00,000 | Rupees Ten Lakh Only |
| 1,00,00,000 | Rupees One Crore Only |
| 25,50,75,000.25 | Rupees Twenty Five Crore Fifty Lakh Seventy Five Thousand and Twenty Five Paise Only |
| 12,00,00,00,000 | Rupees One Thousand Two Hundred Crore Only |
Nothing is uploaded: this runs in your browser.
Runs in your browser; nothing is uploaded.
Put the amount in cell A2 of your sheet.
Copy the formula under "The formula" below and paste it into B2; change A2 if your amount is in another cell.
Press Enter and drag B2 down the column to fill the other rows.
On Excel 2021 or older, paste the VBA function into Insert > Module instead and type =RupeesInWords(A2).
Put the amount in A2 and paste this into B2. It needs LET and LAMBDA, which Excel for Microsoft 365, Excel 2024 and Google Sheets have. Change both A2s if your amount sits elsewhere, then drag the cell down the column.
=LET(amt,ROUND(ABS(A2),2),rup,INT(amt),pai,ROUND((amt-rup)*100,0),unit,{"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},tens,{"","","Twenty","Thirty","Forty","Fifty","Sixty","Seventy","Eighty","Ninety"},upto99,LAMBDA(x,IF(x<20,INDEX(unit,x+1),TRIM(INDEX(tens,INT(x/10)+1)&" "&INDEX(unit,MOD(x,10)+1)))),upto999,LAMBDA(x,TRIM(IF(x>=100,upto99(INT(x/100))&" Hundred ","")&upto99(MOD(x,100)))),upto99k,LAMBDA(x,TRIM(IF(x>=1000,upto99(INT(x/1000))&" Thousand ","")&upto999(MOD(x,1000)))),upto99l,LAMBDA(x,TRIM(IF(x>=100000,upto99(INT(x/100000))&" Lakh ","")&upto99k(MOD(x,100000)))),words,TRIM(IF(rup>=10^7,upto99l(INT(rup/10^7))&" Crore ","")&upto99l(MOD(rup,10^7))),IF(A2<0,"Minus ","")&"Rupees "&IF(rup=0,"Zero",words)&IF(pai>0," and "&upto99(pai)&" Paise","")&" Only")
For 1,25,000.50 in A2 it returns Rupees One Lakh Twenty Five Thousand and Fifty Paise Only. A comma-decimal locale (German, French) uses semicolons between arguments: Excel converts the formula when you paste it into a cell, but Google Sheets may ask you to swap them.
Press Alt+F11, choose Insert, then Module, and paste the code. Close the editor and type =RupeesInWords(A2). Save the workbook as .xlsm, because an ordinary .xlsx drops macros.
' Rupees in words for Excel (Omnikit, theomnikit.com). Free to use and change.
' Usage: =RupeesInWords(A2) gives "Rupees One Lakh Twenty Five Thousand and Fifty Paise Only".
Public Function RupeesInWords(ByVal Amount As Double) As String
Dim Total As Double, Rup As Double, Pai As Double, Result As String
Total = Int(Abs(Amount) * 100 + 0.5)
Rup = Int(Total / 100)
Pai = Total - Rup * 100
If Rup = 0 Then
Result = "Rupees Zero"
Else
Result = "Rupees " & IndianWords(Rup)
End If
If Pai > 0 Then Result = Result & " and " & Upto99(Pai) & " Paise"
If Amount < 0 Then Result = "Minus " & Result
RupeesInWords = Result & " Only"
End Function
Private Function IndianWords(ByVal X As Double) As String
Dim Crore As Double, Rest As Double, Result As String
Crore = Int(X / 10000000)
Rest = X - Crore * 10000000
Result = ""
If Crore > 0 Then Result = BelowCrore(Crore) & " Crore "
IndianWords = Trim(Result & BelowCrore(Rest))
End Function
Private Function BelowCrore(ByVal X As Double) As String
Dim Lakh As Double, Thousand As Double, Hundred As Double, Rest As Double, Result As String
Lakh = Int(X / 100000)
Thousand = Int((X - Lakh * 100000) / 1000)
Hundred = Int((X - Lakh * 100000 - Thousand * 1000) / 100)
Rest = X - Lakh * 100000 - Thousand * 1000 - Hundred * 100
Result = ""
If Lakh > 0 Then Result = Result & Upto99(Lakh) & " Lakh "
If Thousand > 0 Then Result = Result & Upto99(Thousand) & " Thousand "
If Hundred > 0 Then Result = Result & Upto99(Hundred) & " Hundred "
BelowCrore = Trim(Result & Upto99(Rest))
End Function
Private Function Upto99(ByVal X As Double) As String
Dim Units As Variant, Tens As Variant
Units = Array("", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen")
Tens = Array("", "", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety")
If X < 20 Then
Upto99 = Units(X)
Else
Upto99 = Trim(Tens(Int(X / 10)) & " " & Units(X - Int(X / 10) * 10))
End If
End Function
The formula and the VBA function were written for this page and are free to copy and change. Before publishing, both were run as printed over more than 4,000 amounts, from zero paise to 9,99,99,99,99,999.99, and every result matched the cheque line this site's converter gives. Paise are rounded to two places first, the way a bank reads them.
| Question | Answer |
|---|---|
| Number scale | Lakh and crore, with crore counting on above 99 crore |
| Largest amount | 9,99,99,99,99,999.99 |
| Paise | Rounded to two places, written after "and" |
| Negative amounts | Start with Minus, for a ledger, not a cheque |
| Macros needed | Formula: none. VBA: a macro-enabled .xlsm |
| Languages | English; use the converter above for Hindi, Tamil and six more |
Checked on 13 November 2026; the page was last updated on the same day.
Write the words on the cheque's words row exactly as the cell shows them, start with Rupees and end with Only so nothing can be added after. For the same line in Hindi, Bengali, Telugu or another Indian language, type the amount into the converter at the top of this page.
Paste the formula on this page into B2 with the amount in A2 and press Enter. For 1,25,000.50 it returns Rupees One Lakh Twenty Five Thousand and Fifty Paise Only, on the lakh and crore scale. It works in Excel for Microsoft 365, Excel 2024 and Google Sheets without any macro.
No. Excel has no built-in function that spells a number, and Microsoft's SpellNumber sample counts in dollars, million and billion. Use the VBA function on this page instead: paste it into Insert > Module, then type =RupeesInWords(A2). It writes lakh and crore, adds paise after and, and ends in Only.
Use the LET and LAMBDA formula on this page. It is an ordinary cell formula, so the file stays a normal .xlsx and no security warning appears when it opens. LET and LAMBDA need Excel for Microsoft 365, Excel 2024 or Google Sheets; on Excel 2021 or older, use the VBA function.
#NAME? means your Excel lacks LAMBDA, which only Microsoft 365, Excel 2024 and Google Sheets have; Excel 2021 has LET but not LAMBDA, and Excel 2019 has neither. Paste the VBA function on this page into a module instead, save the workbook as a macro-enabled .xlsm and type =RupeesInWords(A2).
Amount ko A2 me likhiye, is page ka formula copy karke B2 me paste kijiye aur Enter dabaiye. 1,25,000.50 ke liye result Rupees One Lakh Twenty Five Thousand and Fifty Paise Only aata hai. Purane Excel me VBA function module me paste kijiye aur =RupeesInWords(A2) likhiye.
The formula and the VBA function write English, the way most Indian cheques and invoices are written. For Hindi, Marathi, Gujarati, Tamil, Bengali, Telugu, Kannada or Malayalam, type the amount into the converter at the top of this page and copy the line, which follows the Unicode CLDR number rules.
Rates and rules change; check the source before you rely on a figure.
Still stuck? Ask about Rupees to Words Converter and anybody who knows can answer. No account needed.
Same job, other tools: Weeks Between Dates – Whole weeks and leftover days between two dates, for school terms, notice and projects · Celsius to Fahrenheit Converter – Celsius to Fahrenheit and back with the exact formula: °F = °C x 1.8 + 32 · BH Series Number Plate Decoder – What 22 BH 1234 AA means: year, Bharat series code, random number and letters · RTO Code List for India – Every state and UT code on Indian plates, and the RTO office behind each number.
In the collection Tax Calculators.