Skip to content
Google Sheets

TEXT function in Google Sheets

Converts a number into text according to a specified format.

=TEXT(number, format)

TEXT syntax and parameters

Two arguments, two required.

  • numbernumberRequired

    The number, date, or time to format.

  • formatstringRequired

    The pattern by which to format the number, enclosed in quotation marks. 0 forces display of zeros if a number has fewer digits than the format specifies. For example, TEXT(12.3,"000.00") produces 012.30. Numbers which have more digits to the right of the decimal point than the pattern are rounded to the indicated number of places. For example, TEXT(12.305,"00.00") results in 12.31. # is similar to 0 but does not force the display of zeros on either side of the decimal point. For example, TEXT(12.3,"###.##") produces 12.3.

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 Excel

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 Google Sheets gets this done.