Skip to main content

CAST

The CAST function converts a value to a specified data type.

Syntax​

=CAST(value, type)

Parameters​

  • value: The value to convert
  • type: The target data type (e.g., "number", "text", "boolean")

Examples​

=CAST("123", "number") // Returns 123 as a number
=CAST(1, "text") // Returns "1" as text
=CAST(1, "boolean") // Returns TRUE