OmniDocHow to Convert Numbers to Words in Excel
Learn how to build an Excel formula that turns an invoice or cheque amount into written words, with setup steps, checks and fixes for common errors.
If you write invoices or cheques from a spreadsheet, you have probably needed the total in words as well as in figures. A total of 1,250.75 has to appear as "One Thousand Two Hundred Fifty and 75/100" on many business documents, and retyping it by hand invites mistakes. People searching for how to Excel formula amount in words are usually trying to avoid exactly that step.
Excel does not include a standard function that spells out numbers. The usual fix is a small custom function that reads the digits, groups them into hundreds, thousands and millions, and writes each group as words. You add it once to the workbook, then call it from any cell, the same way you call SUM.
This article shows you how to set up that function, call it from a cell, and check the result before the amount goes onto a document. It also covers what to do if your organization blocks macros, and how to move the finished line into a PDF invoice.
How do I convert a number to words in Excel? The short answer
Add a custom function to the workbook, then call it from a cell next to your amount. Save the file in a macro-enabled format so the function stays available. The table below shows which route fits your situation.
| Your situation | What to do | Why |
|---|---|---|
| You create the same invoice or cheque many times | Add the custom function to the workbook once and save as a macro-enabled file | The formula works every time you open that file |
| Your organization blocks macros | Use a locked template that already contains the conversion, or ask your IT team to approve the function | Blocked macros stop the function from running at all |
| You need one conversion and do not reuse the file | Convert the amount in a copy of the workbook and paste only the words into the final document | Keeps the function out of a file you share |
| The final document is a PDF | Paste the words into your spreadsheet, then edit the matching line in the PDF after export | Corrects the text without rebuilding the whole invoice |
| You handle amounts in more than one currency | Keep the function for the number part and add the currency name with a simple text join | Currency wording differs by country and changes more often than the number rules |
Before you start
Check these points first. Each one prevents a common failure that looks like a formula error but comes from the setup.
- Make sure the amount is a number. Values pasted from a web page or a PDF often arrive as text. Text cells either return an error or give wrong words. Select the cell and confirm it is aligned to the right, as numbers normally are, or re-enter the value.
- Decide on the currency wording. Cheques usually write the cents as a fraction, such as "75/100", and many invoices add a currency name such as "Dollars". Write down the exact phrase your bank or client expects.
- Confirm that macros are allowed. Some companies block macros for security reasons. If yours does, you cannot run a custom function, so plan the template route described in the table.
- Make a copy of the workbook. Work in a copy while you test. A saved mistake in a master invoice file is harder to undo than a copy you can delete.
- Know your largest amount. Decide the biggest total you will convert, such as a seven-figure contract value. Test that size specifically, because grouping rules are where most conversion functions fail.
Adding an amount-in-words function to your workbook, step by step
- Put the amount in one cell. For example, type 1250.75 in cell A1. Keep the number unformatted in the source cell and apply currency formatting only to the display cell, so the function reads a clean value.
- Open the macro editor. In Excel on Windows, press Alt+F11 to open the built-in editor for the workbook's macros. This is where custom functions are stored.
- Insert a standard module. A module is a container for your code. Create one for the workbook so the function is available to every sheet in that file.
- Add the function. Paste in a function you have reviewed, or write one yourself, and give it a clear name such as AmountInWords. A working version reads the whole-number part, splits it into groups of three digits, names each group with thousand or million as needed, and writes the cents as a two-digit fraction. Read through the code before you trust it, because a small error in the grouping logic produces wrong words that still look plausible.
- Save in a macro-enabled format. Save the file with the macro-enabled workbook type rather than the standard workbook type. A standard file drops the custom function on save, and the formula will show an error the next time you open it.
- Call the function from a cell. Go back to the sheet, select a cell next to the amount, and type =AmountInWords(A1). If you want the currency name added, join it with the result, for example =AmountInWords(A1)&" only". Adjust the wording to match your document.
- Allow macros when prompted. When you open the file, Excel may warn that macros are disabled. Enable content only for files you created or fully trust, and keep the security setting on for files from other sources.
- Move the line into the final document. Copy the result cell and paste it as text into your invoice or cheque layout. If the final file is a PDF, you can edit the paragraph text in the OmniDoc PDF editor on the desktop client at download.omnidoc.top, which is quicker than regenerating the whole document.
Check the result
Test the function with amounts that exercise each part of the logic. Run these checks before any real document uses the formula.
| Check | How to see it | If it's wrong |
|---|---|---|
| Zero | Enter 0 and confirm the result reads "Zero" | Add a special case for zero in the function |
| A single digit and a teen | Enter 7 and 13 and confirm "Seven" and "Thirteen" | Check the lookup of words for numbers under twenty |
| A round hundred and thousand | Enter 100 and 1000 and confirm "One Hundred" and "One Thousand" | Check the grouping and the scale words |
| Cents | Enter 1250.75 and confirm the fraction reads "75/100" | Make sure the decimal part is read as two digits, with a leading zero for amounts like 1.05 |
| A million and beyond | Enter 1000000 and confirm "One Million" | Check that the million group is handled, not only the thousand group |
| Text in the cell | Put a word in A1 and confirm you get a clear error or a blank result | Add an error check so a stray text value does not produce a wrong amount |
| #NAME? error | The cell shows #NAME? | The function is missing or the file was saved in a standard format; re-enable macros or re-add the function |
Read the final sentence for wording problems as well as number problems. Check the words against the amount in figures, and make sure the currency name and the fraction are in the order your bank or client uses. Conventions for cheques differ between countries and institutions, so confirm the format with the party who will receive the document.
📊 At a glance
There are three common ways to get amount-in-words text into a document. The table compares them so you can pick the one that matches how your files are shared.
| Approach | Works well when | Watch out for |
|---|---|---|
| A custom function in the workbook | You create the same invoices or cheques often and macros are allowed | The file must stay macro-enabled, and you must review the code before trusting it |
| A locked template | Several people fill in the same form and changes go through one owner | Edits to the conversion need the template owner, and the template must be maintained |
| A manual check on a converted value | You convert a few amounts occasionally, or macros are blocked | Any online converter may store what you enter, so check its privacy terms before you enter bank details or client names |
❓ FAQ
1. Is there a built-in Excel formula for amount in words?
No. Excel does not include a standard function that writes numbers as words, so you need a custom function or a template that already contains the conversion. Check the function's output with the tests in the table above before you rely on it.
2. Why does my formula show #NAME?
The function is probably missing from the file, or the workbook was saved in a format that does not keep macros. Re-add the function in the macro editor and save the file in a macro-enabled format.
3. How do I handle cents on a cheque?
Most cheque formats write the cents as a fraction, such as "and 75/100". Make sure your function reads the decimal part as two digits, and confirm the exact wording with your bank, since the required format can vary.
4. Can I use this if my company blocks macros?
Not with a custom function. Ask your IT team whether an approved template can include the conversion, or type the words yourself and check them against the figure.
📝 Summary
Converting an amount to words in Excel comes down to adding a custom function, saving the file in a macro-enabled format, and testing it with zero, cents and a million before you use it. If macros are blocked, a reviewed template or a manual check works as a fallback. Whatever method you use, confirm the wording against the format your bank or client requires.
