Convert Numbers to Words in Excel: 4 Easy VBA Steps

MS Excel · VBA · Business Automation

How to Convert Numbers to Words in Excel Using VBA

Convert numbers to words in Excel with a reusable VBA function and a simple add-in. This illustrated guide explains every stage, from opening the Visual Basic Editor to displaying written amounts in invoices, receipts and reports.

Microsoft Excel does not provide a general built-in English number-to-words worksheet function. In this TechBikash28 guide, you will learn how to build an Excel number to words formula, save it as an .xlam add-in and generate wording in both international and Indian currency formats.

Four guided stepsCopyable VBA codeRupees & PaiseDesktop ExcelBy Bikash Sarangi

Excel number-to-words tutorial from TechBikash28.

Why Convert Numbers to Words in Excel?

Businesses often need to display a number and its written equivalent in the same document. When employees manually type amounts in words, the text can become inconsistent if the original figure changes. The ability to convert numbers to words in Excel helps maintain a clear relationship between a calculated amount and its written description.

For example, an invoice may contain an amount of ₹12,345.50. Using a custom VBA function, the words can be generated from the same cell rather than typed separately. This approach is particularly useful for finance, purchasing, administration, quotation templates and payment vouchers.

Try this example

Put 1234.50 in cell A2, then enter =RupeesInWords(A2). Expected result: Rupees One Thousand Two Hundred Thirty Four and Fifty Paise Only.

Fewer manual editsWords update when the cell value changes.

Reusable functionUse the add-in in other desktop Excel workbooks.

Business-ready outputSuitable for invoice and voucher templates after testing.

This number to words in Excel VBA method is designed for learners who want a practical example of business automation, not just a formula to memorise.

Convert Numbers to Words in Excel in 4 Easy Steps

To convert numbers to words in Excel, first create the custom function in a standard VBA module. Then save it as an add-in, enable the file and call the new function from any supported worksheet. The screenshots below show the main Excel menus.

Enable the Developer Tab

Open Excel and choose File → Options → Customize Ribbon. In the Main Tabs list, enable Developer and click OK. If the Developer tab is already visible, you can skip this action.

Enable Developer tab to convert numbers to words in Excel using VBA — Step 1 — Enable the Developer tab in Excel Options.

Open the VBA Editor and Insert a Module

Press Alt + F11, or select Developer → Visual Basic. In the VBA Editor, select the workbook and choose Insert → Module. Paste the complete code from the section below into this standard module, not into Sheet1 or ThisWorkbook.

Excel VBA module for number to words in Excel — Step 2 — Insert a standard VBA module.

Save the Code as an XLAM Add-in

Return to Excel and select File → Save As. Choose Excel Add-in (*.xlam) as the file type. Name the add-in NumberToWords_Excel.xlam and save it in a permanent, trusted folder. Excel must be able to locate this file whenever the add-in loads.

Save Excel number to words formula VBA as an XLAM add-in — Step 3 — Save your VBA workbook as an Excel Add-in.

Enable the Add-in and Enter the Formula

Open File → Options → Add-ins. At the bottom, select Excel Add-ins under Manage and click Go. Click Browse, select your saved XLAM file and tick its checkbox. Return to the worksheet and use either function:

International format: =NumberToWords(A2)

Indian currency: =RupeesInWords(A2)

The original four image links supplied for this tutorial all pointed to the same thumbnail. The activation instructions above are therefore presented as text rather than showing an unrelated screenshot.

Once enabled, the custom function can help you convert numbers to words in Excel without manually retyping an amount each time it changes.

Number to Words in Excel VBA — Complete Copyable Code

This working example defines two worksheet functions. NumberToWords uses Thousand, Million and Billion. RupeesInWords uses the Indian grouping system and returns Rupees and Paise. Copy the entire module below into the standard VBA module you created in Step 2.

TechBikash28 · Number-to-Words VBA Module

Option Explicit

' TECHBIKASH28 - Convert numbers to words in Excel
' International words and Indian Rupees/Paise

Public Function NumberToWords(ByVal InputValue As Variant) As Variant
    On Error GoTo BadValue
    Dim whole As String, paise As String
    Dim negative As Boolean, result As String
    If Not ParseTB28(InputValue, whole, paise, negative) Then GoTo BadValue
    result = IntegerTB28(whole, False)
    If CLng(paise) > 0 Then result = result & " and " & paise & "/100"
    If negative Then result = "Minus " & result
    NumberToWords = result
    Exit Function
BadValue:
    NumberToWords = CVErr(xlErrValue)
End Function

Public Function RupeesInWords(ByVal InputValue As Variant) As Variant
    On Error GoTo BadValue
    Dim whole As String, paise As String
    Dim negative As Boolean, result As String, p As Long
    If Not ParseTB28(InputValue, whole, paise, negative) Then GoTo BadValue
    result = "Rupees " & IntegerTB28(whole, True)
    p = CLng(paise)
    If p > 0 Then
        result = result & " and " & Under100TB28(p)
        If p = 1 Then
            result = result & " Paisa"
        Else
            result = result & " Paise"
        End If
    End If
    result = result & " Only"
    If negative Then result = "Minus " & result
    RupeesInWords = result
    Exit Function
BadValue:
    RupeesInWords = CVErr(xlErrValue)
End Function

Private Function ParseTB28(ByVal v As Variant, _
    ByRef whole As String, ByRef paise As String, _
    ByRef negative As Boolean) As Boolean
    On Error GoTo Failed
    Dim n As Double, s As String, sep As String, i As Long
    If IsError(v) Then Exit Function
    If IsEmpty(v) Then Exit Function
    If Len(Trim$(CStr(v))) = 0 Then Exit Function
    If Not IsNumeric(v) Then Exit Function
    n = CDbl(v)
    If Abs(n) >= 1000000000000# Then Exit Function
    negative = (n < 0)
    s = Format$(Abs(n), "0.00")
    sep = Application.International(xlDecimalSeparator)
    i = InStrRev(s, sep)
    If i = 0 Then Exit Function
    whole = Left$(s, i - 1)
    paise = Mid$(s, i + Len(sep))
    If Len(paise) <> 2 Then Exit Function
    ParseTB28 = True
    Exit Function
Failed:
    ParseTB28 = False
End Function

Private Function IntegerTB28(ByVal digits As String, _
    ByVal indian As Boolean) As String
    Dim groups As Variant, pos As Long, n As Long
    Dim part As String, words As String, result As String
    If indian Then
        groups = Array("", "Thousand", "Lakh", "Crore", "Arab", "Kharab")
    Else
        groups = Array("", "Thousand", "Million", "Billion")
    End If
    Do While Len(digits) > 0
        n = 3
        If indian And pos > 0 Then n = 2
        If Len(digits) < n Then n = Len(digits)
        part = Right$(digits, n)
        digits = Left$(digits, Len(digits) - n)
        If Val(part) <> 0 Then
            words = Under1000TB28(CLng(part))
            If Len(CStr(groups(pos))) > 0 Then _
                words = words & " " & CStr(groups(pos))
            If Len(result) > 0 Then words = words & " " & result
            result = words
        End If
        pos = pos + 1
    Loop
    If Len(result) = 0 Then result = "Zero"
    IntegerTB28 = result
End Function

Private Function Under1000TB28(ByVal n As Long) As String
    Dim result As String, r As Long
    If n >= 100 Then result = DigitTB28(n \ 100) & " Hundred"
    r = n Mod 100
    If r > 0 Then
        If Len(result) > 0 Then result = result & " "
        result = result & Under100TB28(r)
    End If
    Under1000TB28 = result
End Function

Private Function Under100TB28(ByVal n As Long) As String
    Dim tens As Variant, result As String, ones As Long
    If n < 20 Then
        Under100TB28 = DigitTB28(n)
        Exit Function
    End If
    tens = Array("", "", "Twenty", "Thirty", "Forty", _
                 "Fifty", "Sixty", "Seventy", "Eighty", "Ninety")
    result = CStr(tens(n \ 10))
    ones = n Mod 10
    If ones > 0 Then result = result & " " & DigitTB28(ones)
    Under100TB28 = result
End Function

Private Function DigitTB28(ByVal n As Long) As String
    Dim words As Variant
    words = Array("Zero", "One", "Two", "Three", "Four", _
        "Five", "Six", "Seven", "Eight", "Nine", "Ten", _
        "Eleven", "Twelve", "Thirteen", "Fourteen", _
        "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen")
    DigitTB28 = CStr(words(n))
End Function

The code panel scrolls independently. Select “Copy Full VBA Code” to copy the complete text with indentation preserved.

When adding the number to words in Excel VBA module, do not replace regular double quotes with curved quotation marks. Standard quotes are required for valid VBA statements.

Security and accuracy: VBA runs in desktop Excel, not Excel for the web. Review any macro before enabling it. This function accepts numbers below one trillion and formats two decimal places; verify business-critical amounts and rounding before issuing financial documents.

Excel Number to Words Formula — Examples and Outputs

Once the add-in is active, the Excel number to words formula behaves like a custom worksheet function. It reads the amount in the referenced cell and returns a text result. These examples demonstrate how to convert numbers to words in Excel for general figures and currency amounts.

Formula	Expected output
`=NumberToWords(0)`	Zero
`=NumberToWords(125)`	One Hundred Twenty Five
`=NumberToWords(1234.50)`	One Thousand Two Hundred Thirty Four and 50/100
`=NumberToWords(1250467)`	One Million Two Hundred Fifty Thousand Four Hundred Sixty Seven
`=RupeesInWords(1234.50)`	Rupees One Thousand Two Hundred Thirty Four and Fifty Paise Only
`=RupeesInWords(1250467)`	Rupees Twelve Lakh Fifty Thousand Four Hundred Sixty Seven Only
`=RupeesInWords(0.01)`	Rupees Zero and One Paisa Only

For real workbooks, replace the numeric argument with a cell reference such as A2. If the cell value changes, Excel can recalculate the function when workbook calculation is enabled.

Number to Words in Excel Indian Format: Rupees and Paise

The number to words in Excel Indian format differs from the international system because it groups larger figures into Lakhs and Crores rather than Millions and Billions. This distinction matters when preparing Indian invoices, cash vouchers and other financial records.

For example, 1250467 is written as Twelve Lakh Fifty Thousand Four Hundred Sixty Seven in the Indian system, while the international version uses One Million Two Hundred Fifty Thousand Four Hundred Sixty Seven. The RupeesInWords function also converts two decimal places into Paise.

Best formula for Indian invoices

Enter =RupeesInWords(A2) in your amount-in-words field. The number to words in Excel Indian format function will display a Rupees-and-Paise result instead of international number names.

Using this function to convert numbers to words in Excel is convenient for invoice templates, but always review the generated output if the values are used on cheques, legal forms or regulated financial documents.

Troubleshooting Number-to-Words Formulas

If your Excel number to words formula does not work immediately, check the add-in status before editing the code. The most common issues involve disabled add-ins, incorrect function names and inputs that are not numeric.

Problem	What to check
`#NAME?`	Confirm the add-in is enabled and the function name is spelled correctly.
`#VALUE!`	Use a supported numeric value, not text or a blank cell.
Macros blocked	Check the file’s trust status and your organisation’s macro policy. Do not bypass security restrictions.
Missing after reopening	Check that the XLAM file has not moved and is enabled in Excel Add-ins.
Excel in browser	Open the workbook in desktop Excel, which supports VBA functions.

Microsoft’s Excel VBA documentation provides further reference material. For another Excel reporting technique, see the TechBikash28 Excel Consolidate tutorial.

Watch: Convert Numbers to Words in Excel Tutorial

Prefer a visual walkthrough? Watch the TechBikash28 tutorial by Bikash Sarangi to see how to convert numbers to words in Excel, enter a function into the worksheet and understand the add-in process. The updated code in this article also adds a separate Indian currency function.

Watch the Complete YouTube Tutorial

TechBikash28 Excel Web Stories

Explore short visual lessons that complement this convert numbers to words in Excel guide, including quick demonstrations of Excel lookups, Consolidate and dashboard development.

Convert Numbers to Words with an Excel VBA Add-inOpen Web Story Excel Consolidate Function with Real ExamplesOpen Web Story How to Use XLOOKUP in ExcelOpen Web Story Create More Effective Excel DashboardsOpen Web Story

Frequently Asked Questions

Does Excel have a built-in number-to-words formula?

No. There is no general built-in function for this purpose. You can create an Excel number to words formula by adding a custom VBA user-defined function.

Can I convert numbers to words in Excel without VBA?

Alternative methods include add-ins and custom solutions, but this tutorial specifically explains the VBA method because it is reusable in desktop Excel.

How do I convert amounts to words in Indian currency?

Use the number to words in Excel Indian format function =RupeesInWords(A2). It supports Lakhs, Crores, Rupees and Paise.

Can I use the add-in in multiple workbooks?

Yes. Once the XLAM is installed and enabled, Excel can use its public functions across workbooks on the same installation.

Does the VBA code work in Excel Online?

No. Excel for the web does not execute VBA. Open the workbook in desktop Excel instead.

Can I run this code in Google Sheets?

Not directly. Google Sheets requires an equivalent Google Apps Script function rather than VBA code.

Conclusion: Build Useful Excel Automation Skills

Knowing how to convert numbers to words in Excel demonstrates a simple but useful approach to business automation. By building an XLAM add-in, you can reuse a consistent function across compatible Excel workbooks and reduce repetitive typing in routine reporting tasks.

At TechBikash28, the aim is not only to share the number to words in Excel VBA code but also to explain the business reasoning behind a practical solution. These small lessons help learners understand how development tools can support real operational needs.

About TechBikash28 and the author

Bikash Sarangi — Technology Entrepreneur & Developer

Bikash Sarangi is the founder of Kalpavriksh Software and creator of TechBikash28, a personal learning platform for practical technology knowledge. His writing connects business processes with accessible lessons in Excel, Power BI, automation and software development.

TechBikash28 shares educational articles and video tutorials; Kalpavriksh Software is the associated commercial technology business. Explore more technical learning through the TechBikash28 YouTube channel.