Text
Modern
TEXT
Converts a number to text using a format code you specify.
Available in All versions
Syntax
TEXT(value, format_text)What it returns
The number formatted as text.
Arguments
| Argument | Required | Description |
|---|---|---|
value |
Yes | The number to format. |
format_text |
Yes | The number-format code in quotes (e.g. "0.00", "dd/mm/yyyy"). |
Example
Before
1234.5
After
1234.50
TEXT formats a number as text using a format code (here 0.00).
=TEXT(A2, "0.00")Important to know
Format codes are locale-dependent — date codes differ by language (EN dd/mm/yyyy · FR jj/mm/aaaa · IT gg/mm/aaaa).
The result is text and can no longer be used in calculations.