Converts the input value into a number type. If the input isn’t numerical, the function returns Null
Category: conversion
Syntax:
Returns: Number
Context Filtering: ✓ Yes
Parameters
| Name | Type | Required | Description |
|---|
input | text or date or number or column | ✓ Yes | The text, date, or number to convert to number |
Allowed Column Types for input: STRING, TEXT, INT, FLOAT, DECIMAL, DATETIME, DATE
Validation
- Minimum parameters: 1
- Maximum parameters: 1
Examples
Returns 15.25
Result: 15.25
Converts text values to numbers Last modified on March 13, 2026