Skip to main content
Converts the input value into a number type. If the input isn’t numerical, the function returns Null Category: conversion Syntax:
Number(input)
Returns: Number Context Filtering: ✓ Yes

Parameters

NameTypeRequiredDescription
inputtext or date or number or column✓ YesThe 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

Number("15.25")
Returns 15.25 Result: 15.25
Number([Text Column])
Converts text values to numbers
Last modified on March 13, 2026