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 | Refer to Formula usage tips - Converting a number to a Date | |
| Date | Number | |
| Time-formatted List Item | PERIOD() | |
| 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() |
