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.
Additional information
Results for numbers less than 0.001 display in computerized scientific notations. For example, TEXT(0.0001)
= '1.0E-4
'.
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).
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.