How to Convert Numbers into Words in MS Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to spell out numbers as words using a VBA macro in Excel.

Quick summary

Converting numbers to words in Excel requires a custom VBA macro using Microsoft's prebuilt SpellNumber function. This step-by-step process enables users to automatically display numeric values as written text directly within their spreadsheet cells.

Steps

Go to Microsoft 365 and scroll down to find the prebuilt macro function provided by Microsoft.
Copy the code to your clipboard for later use.
Open your Excel file and click File.
Navigate to the Options tab.
Go to Customize Ribbon, check Developer, and click OK.
Open the Developer tab and launch the VBA editor.
In the VBA editor, click Insert > Module to open a blank code window.
Paste the copied code into the VBA editor, press Ctrl + S to save, and close the editor.
In a blank cell, type =NumberText(A2) replacing A2 with the cell holding the number, then press Enter.
The numbers in the selected cells will be converted to word equivalents automatically.
Drag the formula down or across cells to apply the number-to-text conversion to multiple cells.

📌 Why this matters

Converting numbers to words in Microsoft Excel is essential for finance, invoicing, and legal documents where numeric values must be written out in full text to prevent errors or fraud. Excel does not include a native number-to-words function, so this VBA macro method fills a critical gap for professionals who need accurate, automated text output from numeric data. By using Microsoft's prebuilt SpellNumber macro, users can implement this feature quickly without advanced programming knowledge. This tutorial matters because it turns a complex customization into a repeatable, reliable workflow any Excel user can follow.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel