Omnikit
DevFilesMoneyAll toolsExams
Ctrl K
Dev toolsFile toolsMoney calculatorsAll toolsExams
HomeMoney calculatorsRupees to Words ConverterAmount in Words in Excel

Amount in Words in Excel

money

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.
What this does
A copy-paste Excel formula and VBA function for rupees in words.
What it does not do
It does not need an account or a sign-in.
What leaves your browser
Nothing you type or open leaves your device. The page sends only a usage count: the tool’s name and the action, never the content.

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.

What the formula and the VBA function return for some amounts in A2
In A2The cell shows
0.75Rupees Zero and Seventy Five Paise Only
999Rupees Nine Hundred Ninety Nine Only
45,000Rupees Forty Five Thousand Only
1,25,000.5Rupees One Lakh Twenty Five Thousand and Fifty Paise Only
10,00,000Rupees Ten Lakh Only
1,00,00,000Rupees One Crore Only
25,50,75,000.25Rupees Twenty Five Crore Fifty Lakh Seventy Five Thousand and Twenty Five Paise Only
12,00,00,00,000Rupees One Thousand Two Hundred Crore Only
Computed by the converter itself; the formula and the VBA function were run over 4,000+ amounts and matched it on every one.

Nothing is uploaded: this runs in your browser.

Runs in your browser; nothing is uploaded.

Next:
  • Cash Denomination Calculator Count notes and coins by denomination: note counting with the total in figures and words
  • Simple Receipt Maker Make a receipt for a shop sale in seconds, as a PDF or printed on a thermal printer
Embed terms

How to write an amount in words in Excel

1

Put the amount in cell A2 of your sheet.

2

Copy the formula under "The formula" below and paste it into B2; change A2 if your amount is in another cell.

3

Press Enter and drag B2 down the column to fill the other rows.

4

On Excel 2021 or older, paste the VBA function into Insert > Module instead and type =RupeesInWords(A2).

The formula: no macro, Excel 365 and Google Sheets

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.

The VBA function: any Excel since 2007

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

How both were checked

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.

Facts at a glance

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.

Writing it on a cheque

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.

Frequently asked questions

How do I convert an amount to words in Excel in Indian rupees?

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.

Is there a SpellNumber function in Excel for rupees?

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.

How do I write amount in words in Excel without a macro?

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.

Why does the formula show #NAME? in my Excel?

#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).

Excel me amount in words kaise likhe?

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.

Can the Excel formula write the amount in Hindi or Tamil?

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.

Sources

  • Unicode CLDR 49 beta 2, number spell-out rules (Hindi, Marathi, Gujarati, Tamil, Bengali, Telugu, Kannada, Malayalam)

Last verified 29 September 2026.

Figures from Unicode CLDR 49 beta 2, number spell-out rules (Hindi, Marathi, Gujarati, Tamil, Bengali, Telugu, Kannada, Malayalam), read 29 September 2026. Built by Saifuddin, Omnikit.

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.

More ways to use Rupees to Words Converter

  • Rupees to Words ConverterAny amount spelled out for a cheque, in English or eight Indian languages
  • Number to Words ConverterSpell any whole number out in English, with no currency attached
  • Number to Words in HindiNumber to words in Hindi: 50,000 is पचास हज़ार, 12,50,000 is बारह लाख पचास हज़ार
  • Number to Words in MarathiNumber to words in Marathi: 1,500 is एक हजार पाचशे, 45,000 is पंचेचाळीस हजार
  • Number to Words in Gujarati50,000 in Gujarati words is પચાસ હજાર: any number or rupee amount in Gujarati script
  • Number to Words in TamilFifty thousand in Tamil is ஐம்பதாயிரம்: any number or rupee amount in Tamil words
  • Number to Words in BengaliNumber to words in Bengali: 50,000 is পঞ্চাশ হাজার, 1,00,000 is এক লাখ
  • Number to Words in TeluguNumber to words in Telugu: 50,000 is యాభై వేల, 1,00,000 is ఒక లక్ష
  • Number to Words in KannadaNumber to words in Kannada: 50,000 is ಐವತ್ತು ಸಾವಿರ, 1,00,000 is ಒಂದು ಲಕ್ಷ
  • Number to Words in MalayalamNumber to words in Malayalam: 50,000 is അൻപതായിരം, 1,00,000 is ഒരു ലക്ഷം

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.

Read about this

All guides
  • How to count cash by denomination, and split an amount into the fewest notesCount notes and coins by denomination, with the total in figures and words: a drawer of 91 pieces worked to ₹9,587, and the fewest notes for any sum.

Related tools

All money calculators
Date CalculatorDays, weeks and months between two dates, or a date plus or minus days, weeks or monthsTime Zone ConverterOne time shown in several cities at once, daylight saving included, with a meeting gridUnit ConverterLength, weight, volume, temperature, speed, area, data and time, both ways as you typeIndian Number Format ConverterIndian commas (12,34,56,789) and international (123,456,789), lakh and crore to millionShoe Size ConverterUK, India, US men, US women, EU and foot length in cm, converted both waysVehicle Number RTO DecoderType an Indian number plate to see its state, its RTO office and what each part meansForex Markup CalculatorReal cost of a card payment or transfer abroad against the mid-market rate, fees includedIndia–US–UK Working Hours OverlapWhen India and a US or UK team are both at work on a given date, daylight saving included

In the collection Tax Calculators.

Was this tool helpful?
Omnikit

Small jobs, done in your browser. Free, fast and private. Files are never uploaded.

Files

  • Compress Image
  • Image to PDF
  • Merge PDF
  • Compress PDF
  • PDF to Word
  • Word to PDF

Dev

  • JSON Formatter & Validator
  • Base64 Encode & Decode
  • JWT Decoder, Verifier & Encoder
  • Password Generator
  • UUID Generator
  • Unix Timestamp Converter

Money

  • SIP Calculator
  • EMI Calculator
  • GST Calculator
  • FD Calculator
  • PPF Calculator
  • Lumpsum Calculator

Site map: Files · Dev · Money

GuidesQuestionsAboutHow we checkLaw library (beta)PrivacyTermsDisclosureContactMore: Exam practice (UGC NET, MH-SET, PhD entrance, CSIR NET)Runs in your browser. Nothing is uploaded. © 2026 Omnikit (theomnikit.com)