TEXT Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

TEXT is an Excel Text function. Converts a number into text, formatted the way you choose.

TEXT syntax

=TEXT(value, format_text)

TEXT is used to clean up and reshape text data pulled from other systems before reporting on it.

Open the live Excel-style spreadsheet and try TEXT yourself. No Excel install or sign-up needed to start.

What does the TEXT function do in Excel?

Converts a number into text, formatted the way you choose.

What is the syntax of TEXT in Excel?

The syntax is =TEXT(value, format_text). value: The value to evaluate; format_text: The number format to apply.

Where can I practice TEXT online for free?

Open the free live spreadsheet on Cellgrids and try TEXT yourself. No Excel install is needed and you can start without signing up.