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.
Results for numbers less than 0.001 display in computerized scientific notations. For example, TEXT(0.0001) = '1.0E-4'.
Excel equivalent
Related Anaplan functions
Examples
TEXT(Revenue)
In this example, Revenue is a numeric line item.
The formula converts the values of the Revenue line item to be text values. As a result, the line item contains numbers as text and is available for use in text functions such as LEFT and RIGHT.