Convert Numbers to Words in Excel Without VBA

• Macro security. Many companies block macros entirely or warn users before opening a workbook.
• File type. A macro workbook must be saved as .xlsm, which breaks workflows expecting plain .xlsx.
• IT review. Signed certificates, trusted locations, and admin rights add friction to what should be a routine task.

Step-by-Step: Build the NumberToWords Formula

1. Press Ctrl + F3 to open the Name Manager.
2. Click New to create a name.
3. Paste the full formula below into the Refers to box.
4. Name it NUMBERTOWORDS and click OK.
5. Close the dialog, then test in a cell with =NUMBERTOWORDS(A2).
6. Save the workbook as a template so the named function survives. The named ranges guide shows how to store a LAMBDA as a named function and reuse it anywhere in the workbook.

=LAMBDA(num,
    LET(
        n, ABS(num),
        intPart, TRUNC(n),
        fracPart, ROUND((n - intPart) * 100, 0),
        ones, {"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},
        teens, {"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"},
        tens, {"","","Twenty","Thirty","Forty","Fifty","Sixty","Seventy","Eighty","Ninety"},
        scales, {"","Thousand","Million","Billion","Trillion"},
        chunk, LAMBDA(x,
            LET(
                h, INT(x / 100),
                r, x - h * 100,
                t, INT(r / 10),
                u, r - t * 10,
                hs, IF(h = 0, "", INDEX(ones, h + 1) & " Hundred"),
                ts, IF(r < 20, INDEX(IF(r < 10, ones, teens), r + 1 - 10 * (r >= 10)),
                        IF(t = 0, "", INDEX(tens, t + 1) & IF(u > 0, " " & INDEX(ones, u + 1), ""))),
                TRIM(hs & " " & ts)
            )
        ),
        build, LAMBDA(x, scale,
            IF(x = 0, "",
                chunk(x) & IF(scale > 0, " " & INDEX(scales, scale + 1), ""))
        ),
        groups, INT(n),
        g0, INT(groups / 1000000000000),
        g1, MOD(INT(groups / 1000000000), 1000),
        g2, MOD(INT(groups / 1000000), 1000),
        g3, MOD(INT(groups / 1000), 1000),
        g4, MOD(groups, 1000),
        words, TRIM(TEXTJOIN(" ", TRUE,
            IF(g0>0, build(g0,4), ""),
            IF(g1>0, build(g1,3), ""),
            IF(g2>0, build(g2,2), ""),
            IF(g3>0, build(g3,1), ""),
            IF(g4>0, build(g4,0), ""))),
        sign, IF(num < 0, "Negative ", ""),
        whole, IF(INT(n) = 0, "Zero", words),
        result, sign & whole & IF(fracPart > 0, " and " & TEXT(fracPart, "00") & "/100", ""),
        result
    )
)

• LET binds a name to each intermediate step, so the formula stays readable instead of one gigantic nested expression.
• ABS(num) strips the sign; TRUNC isolates the integer part and the cents are pulled out as fracPart.
• The three lookup arrays (ones, teens, and tens) hold the English word tables. A helper chunk converts any 0–999 block into words ("Two Hundred Fifty").
• The build helper attaches the scale word: thousand, million, billion, trillion.
• The number is sliced into groups of three with MOD and INT, each group is converted, and TEXTJOIN stitches them together with spaces.
• Finally the sign and any cents are appended as a fraction (50/100), matching how amounts appear on cheques.

Naming and Reuse

A Full Worked Example

1. The formula takes the absolute value and splits it: intPart = 3452108, fracPart = 75.
2. The integer is sliced into groups of three from the right: 3 | 452 | 108.
3. Each group runs through chunk: 3 → "Three," 452 → "Four Hundred Fifty-Two," 108 → "One Hundred Eight."
4. build attaches the scale names, producing "Three Million Four Hundred Fifty-Two Thousand One Hundred Eight."
5. The sign is empty (the value is positive), and the cents become and 75/100.
6. The result is Three Million Four Hundred Fifty-Two Thousand One Hundred Eight and 75/100.

=LAMBDA(val, cur,
    LET(
        base, NUMBERTOWORDS(val),
        SUBSTITUTE(base, "and", cur & " and")
    )
)(A2, "Dollars")

1. Version support. LAMBDA needs Microsoft 365. On older Excel the name is undefined and you get #NAME?. Fall back to VBA or Power Query.
2. Very large numbers. The formula is reliable up to the trillions. Beyond that, Excel itself loses integer precision, so the words will drift from the digits.
3. Negative and zero values. The formula prefixes Negative for values below zero and returns Zero for 0, so both cases stay readable.
4. Locale separators. In some regions 1,250 is interpreted as a decimal. Normalize your input with VALUE() before converting so thousands and cents are not swapped.
5. Performance. If you convert thousands of rows, calculate once and paste values, because a long LAMBDA recalculates on every edit.

• Save the named function in a workbook template so every new report inherits it without re-pasting the formula.
• Combine with TEXT and cell formatting so the numeric cell and the spelled-out text never disagree in the final printout.
• Keep the formula readable by wrapping it in LET, as the LET function guide explains. LET keeps the long LAMBDA readable and maintainable.
• Store the raw NUMBERTOWORDS without currency separately from the formatted wrapper, so you can swap currencies on the fly.

• Forgetting the quotation marks around the currency label string inside the LAMBDA.
• Assuming LAMBDA runs on Excel 2019. It will not, and the whole workbook will throw #NAME?.
• Not handling 0 or decimals, which produces blank or garbled output.
• Converting a cell whose content is text with a leading apostrophe; normalize with VALUE() first.
• Pasting the formula into a cell instead of the Name Manager. This is a named function definition, not a working formula you edit inline.

• Is there a built-in number-to-words function in Excel? No. You build one with LAMBDA, or fall back to VBA.
• Can I do it without VBA and without Microsoft 365? Only via an extremely long SUBSTITUTE chain, which is impractical to maintain.
• How do I handle Indonesian Rupiah? The formula is English-only. Convert the value to USD first, then run NUMBERTOWORDS with a "Dollars" label.
• Can I share this with colleagues? Yes. It is a plain .xlsx workbook with no macro, so it opens without a macro prompt and works for colleagues who use Excel 365.