Skip to content
Excel

TEXT function in Excel

Formats a number and converts it to text

=TEXT(value, format_text)

TEXT syntax and parameters

Two arguments, two required.

  • valuenumberRequired

    A numeric value that you want to be converted into text.

  • format_textstringRequired

    A text string that defines the formatting that you want to be applied to the supplied value.

TEXT examples

Formulas you'll actually reuse.

  1. A date rendered as readable text for a message or a label:

    =TEXT(B2, "mmm d, yyyy")

    Result"Aug 14, 2026"

  2. Currency formatting survives concatenation only if TEXT applies it first:

    ="Total: " & TEXT(SUM(C2:C200), "$#,##0.00")

    Result"Total: $148,200.00"

TEXT in Google Sheets

Same name — your formula ports as-is.

Try TEXT in the playground

Edit the example — nothing to install.

Preloaded with the TEXT formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.