NUMBERVALUE
Converts text to number in a locale-independent manner
Syntax
NUMBERVALUE(text, [decimal_separator], [group_separator])
Parameters
- text: Required. The text to convert to a number
- decimal_separator: Optional. The character used as the decimal separator in text
- group_separator: Optional. The character used as the group separator in text
Example
=NUMBERVALUE("2.500,27", ",", ".")