NUMBERVALUE

The NUMBERVALUE function converts text to a number in a locale-independent way.

Syntax

=NUMBERVALUE(text, [decimal_separator], [group_separator])

Parameters

• text: The text to convert to a number
• decimal_separator: Optional. The character used as decimal separator (default is ".")
• group_separator: Optional. The character used as group separator (default is ",")

Examples

=NUMBERVALUE("123.45") // Returns 123.45
=NUMBERVALUE("123,45", ",", ".") // Returns 123.45
=NUMBERVALUE("1.234,56", ",", ".") // Returns 1234.56