1. Calculation functions
  2. Functions
  3. Convert between Data Types

Some Functions are specifically for converting the type of data to allow it to be used in a different context, for example, using a number in a text-only cell. See Converting a number to a Date in Formula Usage Tips.

Use the table below to quickly 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

DAY()

MONTH()

YEAR()

Time-formatted List Item

PERIOD()

Time-formatted List Item

Number

MONTH()

YEAR()

Time-formatted List Item

ITEM()
Text

CODE()

NAME()

List Item

List Item

ITEM()
Text

CODE()

NAME()

Text Number VALUE()
Date DATE()

Time-formatted List Item

FINDITEM()

List Item

FINDITEM()