The TEXT() function converts numeric values to text.
For example, you can use the TEXT function to convert numeric values to text values for use in other functions that require text-based arguments.
Syntax
TEXT(Number to convert)
Arguments
| Argument | Data type | Description |
| Number to convert | Number | The value to convert to text. |
The TEXT function returns a text result.
Calculation engine functionality differences
In Polaris, the TEXT function returns a text value of NaN when used with the numerical value NaN.
In the Classic Engine, the TEXT function returns a blank value when you use it with the numerical value value NaN (Not a Number).
Additional information
Results for numbers less than 0.001 display in computerized scientific notations. For example, TEXT(0.0001) = '1.0E-4'.
Excel equivalent
Examples
Convert a Number to a Text
In this example, the line item Number with a Number data type is converted to a Text data type using the formula TEXT(Number). As a result, the line item contains numbers as text and is available for use in text functions such as LEFT and RIGHT.
| Jan 25 | Feb 25 | Mar 25 | Apr 25 | May 25 | |
| Number | 1 | 2 | 3 | 4 | 5 |
TextTEXT(Number) | 1 | 2 | 3 | 4 | 5 |
Convert a Date to a Text
In this example, the line item Date with a Date data type is converted to a Text data type using the formula TEXT(DAY(Date)) & "/" & TEXT(MONTH(Date)) & "/" & TEXT(YEAR(Date)).
| Jan 25 | Feb 25 | Mar 25 | Apr 25 | May 25 | |
| Date | 01/01/2025 | 01/02/2025 | 01/03/2025 | 01/04/2025 | 01/05/2025 |
TextTEXT(DAY(Date)) & "/" & TEXT(MONTH(Date)) & "/" & TEXT(YEAR(Date)) | 1/1/2025 | 1/2/2025 | 1/3/2025 | 1/4/2025 | 1/5/2025 |
