Google Sheets function
TEXT function in Google Sheets
TEXT in Google Sheets converts a number, date, or time into text using a format pattern in quotation marks. The pattern controls details such as decimal places, leading zeros, currency symbols, or date parts. Because the result is text, it is best suited to display labels.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=TEXT(number, format)Arguments
| Argument | Required | What it means |
|---|---|---|
number | Yes | The number, date, or time to format. |
format | Yes | The format pattern, enclosed in quotation marks. |
Examples
Format a price label
| A | |
|---|---|
| 1 | Amount |
| 2 | 1250 |
=TEXT(A2,"$0.00")Result: $1250.00
The format adds a currency symbol and forces two decimal places.
Common mistakes
Leaving the format pattern outside quotation marks.
Write the pattern as text, such as "$0.00".
Expecting the result to remain numeric.
TEXT returns text. Keep the original numeric cell for later calculations.