Skip to main content

NUMBERVALUE

Converts text to a number using locale-aware decimal and group separators. Handles trailing % sign.

CategoryText
SyntaxNUMBERVALUE(text, [dec_sep], [grp_sep])

Parameters

ParameterRequiredDescription
textRequiredThe text to convert to a number.
dec_sepOptionalThe decimal separator character. Defaults to ".".
grp_sepOptionalThe group (thousands) separator character. Defaults to ",".

Example

NUMBERVALUE("text")

Auto-generated from the EngCanvas function registry.