There are dedicated functions in Anaplan that convert the type of data to enable their use in a different context. For example, when you want to use a number in a text-only cell.
Use the table below to reference the available functions.
| Convert From | Convert to | Function |
| Number | Text | TEXT() |
| Date | DATE() Refer to Formula usage tips - Converting a number to a date | |
| Date | Number | |
| Time-formatted list item | PERIOD() | |
| Text | TEXT() | |
| Time-formatted list item | Number | |
| Time-formatted list item | ITEM() | |
| Text | ||
| List item | List item | ITEM() |
| Text | ||
| Text | Number | VALUE() |
| Date | DATE() | |
| Time-formatted list item | FINDITEM() | |
| List item | FINDITEM() |
