Convert Numbers to Words in Excel: 4 Simple Methods

Need a simpler way to convert amounts into words in Excel? Learn 4 practical methods for accurate number-to-text conversion. For a more efficient spreadsheet workflow, use Kimi Sheets to automate data processing, improve formatting, and work smarter with AI.

Try Kimi Sheets

11 min read2026-08-12

An easy way to convert numbers to words in Excel: Kimi Sheets

Creating invoices, receipts, or financial documents often requires writing numerical amounts in words, but converting each value manually can be time-consuming and prone to errors. Learning how to convert amounts in numbers to words in Excel helps automate this process, improve accuracy, and save time when preparing professional documents. In this guide, we’ll explore four easy methods to convert numeric values into words directly in Excel.

Overview of 4 methods to convert numbers into words in Excel

Converting numerical values into written text can simplify invoice creation, financial reporting, and documentation tasks. Whether you need an amount in words Excel format or want to automate the process, Excel provides multiple ways to convert numbers into words, including AI tools, built-in features, formulas, and custom functions. The table below compares four practical methods to help you choose the best approach based on ease of use, automation level, and technical requirements.

Method	Difficulty level	Automation	Requires coding	Suitable for
Kimi Sheets	Easy	High	No	Quick and automatic number-to-word conversion
Excel Copilot	Easy	High	No	AI-assisted Excel tasks
VBA Code	Medium	High	Yes	Custom number-to-word solutions
Excel Formula	Medium	Medium	No	Macro-free number-to-word conversion using built-in functions

How to convert numbers to words in Excel automatically with AI?

AI-powered spreadsheet tools can simplify the process of converting numeric values into written text without requiring complex formulas or VBA code. With Kimi Sheets, an AI Excel agent, you can automatically convert numbers into words in Excel by uploading your spreadsheet, providing simple instructions, and letting AI generate the results instantly. Follow these simple steps to convert numbers into words in Excel using Kimi Sheets.

Step 1: Upload the Excel file and enter a prompt

Upload your Excel spreadsheet containing the numerical values you want to convert. Then, provide a clear prompt explaining the required conversion format.

Convert all numbers in the "Amount" column into words. Create a new column named "Amount in Words" and fill it with the corresponding text values. Keep the original numbers unchanged and format the results clearly for invoice and financial reporting purposes.

Try Kimi Sheets

Upload the Excel file and enter a prompt

Step 2: Let AI process and generate results

Kimi Sheets will analyze your spreadsheet, identify the numeric values, and automatically convert them into written amounts. The AI handles the conversion process without requiring manual formulas.

Step 3: Preview and download the Excel file

Review the generated amount in words Excel results to ensure accuracy. Once satisfied, download the updated Excel file and use it for invoices, reports, or other financial documents.

Try Kimi Sheets

Key features of Kimi Sheets

Beyond converting numbers into words, Kimi Sheets offers several AI-powered features that simplify spreadsheet tasks and improve productivity. Some of the key features that make it useful for managing Excel workflows include:

Automate repetitive spreadsheet workflows

When working with invoices, financial records, or reports, manually converting numbers into words can take significant time. Kimi Sheets automates repetitive spreadsheet tasks, helping reduce manual effort and improve workflow efficiency.

Process multiple number entries faster

Kimi Sheets can handle large datasets by processing multiple rows of numerical values at once. This makes it easier to convert amounts across invoices, payment records, and financial spreadsheets without updating each entry individually.

Create cleaner financial documents

Kimi Sheets helps organize and format spreadsheet data for better presentation. It allows users to create professional financial documents that include both numeric values and their written equivalents.

Understand and modify complex spreadsheet formulas

For users who need custom numbers-to-words conversion in an Excel formula, Kimi Sheets can explain existing formulas, suggest improvements, and help modify spreadsheet logic based on specific requirements.

Simplify Excel data management with AI

In addition to number-to-word conversion, Kimi Sheets supports various spreadsheet tasks such as data organization, formula generation, table formatting, and data analysis. This helps users manage Excel workflows more efficiently with AI assistance.

How to convert numbers to words in Excel using built-in tools?

Excel does not include a direct function for converting numbers into words, but you can use built-in tools and customization options to automate the process. The following methods explain three simple approaches to converting numbers into words in Excel, including Copilot, VBA, and the SpellNumber tool.

Method 1: Use the COPILOT tool

Microsoft Copilot in Excel provides an AI-powered way to convert numbers into words without creating complex formulas or macros. By using a simple prompt with cell references, Copilot can understand the values, convert them into written amounts, and even handle different formats such as currencies or languages. Here is how to convert numbers to words in Excel.

Step 1: Select Copilot and enter a prompt

Open your Excel worksheet and activate Copilot. Enter a clear prompt inside quotes and reference the cells containing the numbers you want to convert.

Example prompt:

These are prices in US dollars. Convert each number into words in English.

Step 2: Let Copilot convert numbers into words

Copilot analyzes the referenced cells and automatically converts numeric values into written text. For example, 123,568 can be converted into one hundred twenty-three thousand five hundred sixty-eight dollars.

Step 3: Review and customize results

Review the converted values for accuracy and adjust your prompt to customize the output format, such as changing currencies, languages, or formatting styles for different amounts in words Excel requirements.

Method 2: Use VBA code tool

VBA is a powerful way to create a custom function that converts numbers into words in Excel. By adding a VBA code module, you can create a reusable number-to-words in Excel formula that automatically changes numeric values into written text whenever needed. This method is especially useful for invoices, receipts, and financial documents that require frequent conversions.

Step 1: Add the VBA code module

Open your Excel workbook and press Alt + F11 on your keyboard to open the VBA editor. From the top menu, select "Insert" > "Module" to create a new VBA module.

Step 2: Paste the VBA code

Copy the complete VBA code for the number-to-word conversion function and paste it into the newly created module. Make sure the entire code is added correctly without changing any lines.

Function SpellNumber(ByVal N As Currency) As String

    Const Thousand = 1000@
    Const Million = Thousand * Thousand
    Const Billion = Thousand * Million
    Const Trillion = Thousand * Billion

    If N = 0 Then
        SpellNumber = "zero"
        Exit Function
    End If

    Dim Buf As String
    If N < 0 Then
        Buf = "negative "
    Else
        Buf = ""
    End If

    Dim Frac As Currency
    Frac = Abs(N - Fix(N))

    N = Abs(Fix(N))

    If N >= Trillion Then
        Buf = Buf & SpellNumberDigitGroup(Int(N / Trillion)) & " trillion"
        N = N - Int(N / Trillion) * Trillion
        If N >= 1 Then Buf = Buf & " "
    End If

    If N >= Billion Then
        Buf = Buf & SpellNumberDigitGroup(Int(N / Billion)) & " billion"
        N = N - Int(N / Billion) * Billion
        If N >= 1 Then Buf = Buf & " "
    End If

    If N >= Million Then
        Buf = Buf & SpellNumberDigitGroup(Int(N / Million)) & " million"
        N = N - Int(N / Million) * Million
        If N >= 1 Then Buf = Buf & " "
    End If

    If N >= Thousand Then
        Buf = Buf & SpellNumberDigitGroup(Int(N / Thousand)) & " thousand"
        N = N - Int(N / Thousand) * Thousand
        If N >= 1 Then Buf = Buf & " "
    End If

    If N >= 1 Then
        Buf = Buf & SpellNumberDigitGroup(N)
    End If

    SpellNumber = Buf

End Function


Private Function SpellNumberDigitGroup(ByVal N As Integer) As String

    Const Hundred = " hundred"

    Dim Ones As Variant
    Ones = Array("", "one", "two", "three", "four", "five", "six", _
                 "seven", "eight", "nine", "ten", "eleven", _
                 "twelve", "thirteen", "fourteen", "fifteen", _
                 "sixteen", "seventeen", "eighteen", "nineteen")

    Dim Tens As Variant
    Tens = Array("", "", "twenty", "thirty", "forty", "fifty", _
                 "sixty", "seventy", "eighty", "ninety")

    Dim Buf As String
    Buf = ""

    If N >= 100 Then
        Buf = Ones(Int(N / 100)) & Hundred
        N = N Mod 100
        If N > 0 Then Buf = Buf & " "
    End If

    If N >= 20 Then
        Buf = Buf & Tens(Int(N / 10))
        N = N Mod 10
        If N > 0 Then Buf = Buf & "-"
    End If

    If N > 0 Then
        Buf = Buf & Ones(N)
    End If

    SpellNumberDigitGroup = Buf

End Function

Step 3: Save and enable macros

Save the workbook as an "Excel Macro-enabled Workbook (.xlsm)" and enable macros from the Excel Trust Center settings. This allows the custom VBA function to run properly in your spreadsheet.

Step 4: Convert numbers into words using the function

Enter your number in a cell and apply the VBA function (such as SpellNumber) to convert it into words automatically. You can also customize the text format, such as changing the output to the proper case for cleaner presentation.

Method 3: Use an Excel Formula

This method uses Excel formulas to convert numeric values into written text without requiring VBA or additional tools. By combining functions like TEXT, LEFT, MID, and CHOOSE, Excel can process individual digits and generate the corresponding number words automatically.

Step 1: Prepare your Excel data

Enter the numbers you want to convert into an Excel column. For example, add your values in Column E starting from cell "E2."

Step 2: Insert the number-to-word formula

Select the cell where you want the converted text to appear, such as "F2". Enter a formula that references your numeric value.

For example:

=CHOOSE(LEFT(TEXT(E3,"000000000"))+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine")

This formula converts individual digits into their corresponding words. For complete number-to-word conversion, you may need to combine additional IF, MID, and CHOOSE functions to handle hundreds, thousands, millions, and decimal values.

Step 3: Apply the formula and review results

Drag the fill handle down to apply the formula to other values in the column. Review the converted text and adjust the formula output if you need to add currency names or change the formatting style.

Pro tips when converting numbers to words in Excel

To get accurate and professional results when converting numbers into words in Excel, follow these simple best practices. These tips can help improve formatting, prevent errors, and make your spreadsheets easier to manage for invoices, reports, and financial records.

Use SpellNumber for currency formatting

SpellNumber is useful when you need to convert numeric values into written currency amounts for invoices, checks, or payment records. It helps maintain a consistent format by adding currency details to the converted text.

Round decimals before converting values

Before converting values, round decimal numbers when necessary to ensure the written amount matches the final calculation. This prevents errors when working with financial data that includes cents or decimal values.

Keep the original number column hidden

Keep the original numeric values in a separate column and hide them if needed for a cleaner spreadsheet layout. This allows you to preserve the source data while displaying only the converted text.

Test the formula in large numbers

Always test your number-to-words in Excel formula with different values, including large numbers and decimals. This helps confirm that the conversion works correctly for thousands, millions, and complex amounts.

Add currency name after conversion

Include the currency name, such as dollars or cents, after the converted text to make the output clearer. This is especially helpful for invoices and financial documents where the amount format needs to be easily understood.

Avoid VBA for shared macro-free files

VBA solutions can automate number-to-word conversion, but they require macros to be enabled. For shared files that do not support macros, consider using AI-powered tools or other Excel alternatives.

Label cells clearly for auditing

Use clear column names such as "Amount," "Amount in Words," and "Converted Value" to make spreadsheets easier to review. Proper labeling improves transparency and helps users verify converted results quickly.

Conclusion

Converting numbers into words in Excel can save time, improve accuracy, and make financial documents easier to manage. Whether you use AI-powered tools like Kimi Sheets, Excel Copilot, VBA functions, or custom formulas, each method provides a practical way to convert numbers into words in Excel based on your workflow and technical needs. By choosing the right approach, you can automate repetitive tasks and create cleaner, more professional invoices, reports, and spreadsheets.

Try Kimi Sheets

FAQ

Why convert numbers to words in Excel?

Converting numbers into words in Excel is useful for creating professional invoices, checks, receipts, and financial documents. It reduces manual typing, minimizes errors, and ensures that numeric values are clearly represented in written form. This is particularly helpful when handling large amounts or repeated financial entries.

What formula converts numbers to words in Excel?

Excel does not have a built-in formula specifically for converting numbers into words. However, you can create a custom number-to-words formula in Excel using functions like TEXT, LEFT, MID, and CHOOSE, or use VBA-based functions for automation. AI tools and Excel Copilot also provide simpler alternatives for this task.

Can I convert large numbers into words in Excel?

Yes, you can convert large numbers into words in Excel with the help of VBA functions, custom formulas, or AI-powered spreadsheet tools. However, traditional formula-based methods may have limitations when handling very large numbers or complex formatting requirements. Kimi Sheets provides a more flexible way to process spreadsheet tasks by helping you transform, organize, and manage data with natural language instructions. For large financial values or business reports, AI-powered tools can simplify the conversion process and reduce manual effort.