Excel Number to Text: Formulas, Limits, and Options

To turn a number into formatted text in Excel, use the TEXT function: with a number in A2, enter =TEXT(A2,"0.00") to return text showing two decimal places. If you mean spelling a number out in words, such as “123” becoming “one hundred twenty-three,” Excel has no built-in worksheet function for that; you need a custom VBA function, an add-in, or another tool.

What “number to text” can mean

The phrase can describe two different tasks, and choosing the right one matters. Most spreadsheet formulas need a numeric value for arithmetic, sorting, and comparisons. But a report, label, or export may need the number displayed in a particular way as text. A third request is to spell the number using words, often for invoices or checks. The TEXT function handles the second task, not the third.

Format a number as text: turn 12.5 into the text “12.50,” for example.
Store digits as text: keep an identifier such as 00127 without Excel treating it as a quantity.
Spell a number in words: turn 127 into “one hundred twenty-seven.” This requires a separate solution.

These results are not interchangeable. A value that looks like a number may be stored as text, and a numeric value can be displayed with currency symbols or leading zeros without becoming text. Determine whether you need a visual format, a text value, or words before changing the data.

Use TEXT to create formatted text

TEXT takes a value and a format code, then returns a text string that follows that format. With a numeric value of 1234.5 in A2, enter =TEXT(A2,"#,##0.00"); the result is the text “1,234.50” in a typical English-language format. The number itself is not changed, but the formula result is text.

Common format codes include:

0 requires a digit in that position; use it for fixed decimal places or leading zeros.
# displays a digit when present but does not force an otherwise unnecessary zero.
, adds a thousands separator in a format such as #,##0.
. marks the decimal position in the format code; the displayed separator may follow your regional settings.
% displays a value as a percentage and scales it by 100.
Date codes such as yyyy-mm-dd format an Excel date serial as a date string.

For example, with 0.256 in A2, use =TEXT(A2,"0.0%"); it returns the text “25.6%.” With the date 15 March 2026 in A2, use =TEXT(A2,"yyyy-mm-dd"); it returns “2026-03-15,” assuming A2 contains a valid Excel date. Date codes are case-sensitive in meaningful ways: m represents a month in a date context, while mm gives a two-digit month; hh represents hours.

Excel uses number-format codes in TEXT that are similar to the codes in the Format Cells dialog, but a format code is not simply ordinary text. If a code produces an unexpected display, test it on a sample value and check your locale’s decimal and thousands separators. A format can change how a number appears; it does not perform rounding in the underlying value. The text output, however, contains only the digits and characters shown by that format.

Keep leading zeros in codes and IDs

Excel often removes leading zeros when it interprets an entry as a number. That behavior is usually unsuitable for ZIP codes, product codes, or account identifiers, because those values are labels rather than quantities. If A2 contains the numeric value 127 and you want five digits, enter =TEXT(A2,"00000"); the result is the text “00127.” The zero placeholders require Excel to show five digit positions.

If the original zeros have already been discarded, a number format can make them appear again when the value is known to have a fixed width. For a column of identifiers, select the cells, open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, choose Custom, and enter a code such as 00000. That changes the display, not the stored value. To create text for a downstream system or a concatenated label, use TEXT instead.

When importing new identifiers, you can set the destination column to Text before entering or importing the data. For an existing range, Data > Text to Columns can convert values: select the range, choose the Text column data format in the wizard, and finish. Review the preview and keep a copy of the source first, especially when the column contains mixed content. If Excel has already discarded zeros and the identifiers do not all have a known fixed length, the missing information cannot be inferred reliably.

Join formatted numbers to words

When placing a number inside a sentence, format it before joining it to the other text. With a price of 49.9 in B2, enter ="Total: "&TEXT(B2,"$0.00"); the result is the text “Total: $49.90” in a locale that uses the dollar sign and decimal point. The ampersand joins text pieces, while TEXT controls how the numeric piece appears.

This approach is useful for labels, notification messages, and report headings. It also avoids a common surprise: direct concatenation may show a number in its general representation rather than with the currency, decimal places, or date format visible in the source cell. The displayed format of a cell is not automatically carried into a text string.

Remember that the final joined result is text, so Excel cannot use it directly as a numeric value in calculations. Keep the original numeric cell for sums and calculations, and create a separate presentation formula for the label. This separation makes the workbook easier to audit and prevents a formatted report string from being mistaken for source data.

Convert text back into a number

The reverse task is also common: imported data may contain digits stored as text. With the text “1234.50” in A2 in a locale that recognizes a period as the decimal separator, enter =VALUE(A2); the result is the numeric value 1234.5. You can then apply a number format to display two decimal places without converting it back to text.

VALUE works when the text follows a number format Excel recognizes. For imported text with explicit decimal and grouping separators that differ from the computer’s regional settings, NUMBERVALUE can specify those separators. With the text “1.234,50” in A2, use =NUMBERVALUE(A2,",",".") to return the numeric value 1234.5: the second argument identifies the decimal separator and the third the group separator. Check the source format before converting a large dataset; a comma can mean a decimal mark in one system and a thousands mark in another.

Text that contains currency symbols, spaces, nonbreaking spaces, or other characters may need cleaning before conversion. Do not assume that changing the cell’s number format will convert text to a number; number formatting affects numeric values, not text strings. For a large import, use a small sample first and verify the converted values and totals.

Why TEXT output can cause problems

Because TEXT returns text, a result that looks numeric may not behave like a number. For example, text values can sort differently from numeric values, and arithmetic may require another conversion. If the purpose is only to display two decimal places in a worksheet, format the original cells instead of using a formula. On Windows, select the cells and use Home > Number to choose a number format, or open Format Cells with Ctrl+1. On Mac, Command+1 opens Format Cells; ribbon labels and layout can vary by Excel release.

Use TEXT when the formatted characters themselves are needed, such as in a label or an export. Use ordinary cell formatting when the value should remain numeric for calculations. Also remember that a formula result changes when its source value changes, whereas typing a text representation manually does not update automatically.

Unexpected separators: decimal and thousands marks depend partly on regional settings. Confirm how the destination system expects them.
Dates showing as serial numbers: dates are stored as numbers in Excel. Apply a date format to the value or use a date code with TEXT when building a string.
Leading zeros disappear: use a text destination for identifiers, or use a fixed-width format if the required length is known.
Calculations stop working: check whether the formula returns text and convert it back only when numeric calculations are intended.

Can Excel spell numbers out in words?

There is no built-in Excel worksheet function that converts an arbitrary number into English words. TEXT changes the display format; it does not turn 125 into “one hundred twenty-five.” This distinction is a frequent source of confusion because both tasks are described as “number to text.”

To spell amounts, options include a custom VBA user-defined function, an add-in, or an external document or accounting system designed for check-writing. A VBA function can be called from a worksheet after it is added to a workbook, but it is custom code rather than a standard Excel function. Its behavior must be checked for the required language, currency, decimal wording, negative values, and large-number limits. Macro-enabled workbooks also require appropriate security settings, and some organizations block macros.

If you use VBA, save a separate copy of the workbook before running or installing code. Macro actions cannot be undone with Ctrl+Z. Excel for the web does not run VBA macros; use desktop Excel for that approach. Office Scripts are a different automation technology and are not interchangeable with worksheet formulas or VBA. For a one-off conversion, a trusted external tool may be simpler, but consider privacy before uploading financial or personal data.

Choosing the right method

Use this quick guide to avoid converting data unnecessarily:

Need a visible currency, date, percentage, or fixed decimal display? Format the numeric cells if calculations still matter.
Need formatted characters inside a sentence or a text export? Use TEXT, then join the result if needed.
Need to preserve an identifier such as 00042? Store it as text or use a fixed-width TEXT result when the width is known.
Need to calculate with imported digit strings? Convert with VALUE or, where separator control is needed, NUMBERVALUE.
Need “42” written as “forty-two”? Choose a suitable custom function or specialized tool; TEXT does not do this.

For Microsoft 365 on Windows, these core functions are available in standard worksheet use. The same basic TEXT, VALUE, and NUMBERVALUE approach is available in current Excel for Mac, though ribbon organization and regional settings may differ. Excel for the web supports common worksheet formulas, but it cannot run VBA macros. If a workbook will be opened in older Excel versions or another spreadsheet program, test the formulas and any custom code in the actual target environment.

Frequently Asked Questions

What is the Excel function to convert a number to text?
Use TEXT when you want a formatted text result. It needs a value and a format code, and the returned value is text rather than a number.

How do I convert a number to words in Excel?
Excel has no built-in worksheet function for spelling numbers out. Use a suitable VBA user-defined function, an add-in, or another trusted tool, and confirm that it supports your language and currency rules.

Does TEXT change the original number?
No. It returns a separate text result based on the number and format code. The source cell remains numeric unless you replace it manually.

How can I keep zeros at the start of a number?
For identifiers, store the entry as text or apply a fixed-width format when its length is known. Use TEXT when you need a text result with those zeros, rather than just a display change.

Why can’t I add cells that contain numbers made with TEXT?
TEXT returns text, even when the result looks like digits. Keep a numeric source value for calculations, or convert the text back to a number if the contents use a format Excel can interpret.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.