NUMBERVALUE function
Summary
Converts text to number in a locale-independent manner
Syntax
NUMBERVALUE(Text, [Decimal_separator], [Group_separator ])
The NUMBERVALUE function syntax has the following arguments.
• Text Required. The text to convert to a number.
• Decimal_separator Optional. The character used to separate the integer and fractional part of the result.
• Group_separator Optional. The character used to separate groupings of numbers, such as thousands from hundreds and millions from thousands.
• Text Required. The text to convert to a number.
• Decimal_separator Optional. The character used to separate the integer and fractional part of the result.
• Group_separator Optional. The character used to separate groupings of numbers, such as thousands from hundreds and millions from thousands.
Example
=NUMBERVALUE("2.500,27",",",".")
=NUMBERVALUE("3.5%")
=NUMBERVALUE("3.5%")