Excel Function

TEXT

Formats value as text using a format code.

TEXT(value, format_text)

Arguments

value

Required

Specify a single cell reference.

format_text

Required

Enter a text value (wrap with quotes when needed).

Practice Preview

format and display text values. Use TEXT to Formats value as text using a format code. use "#,##0" for format_text. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=TEXT(D2, "#,##0")

Practice This Function

Practice in Sequential Mode Back to Function List