NUMBERVALUE function

The NUMBERVALUE function is one of the text and data functions. Is used to convert text to a number, in a locale-independent way. If the converted text is not a number, the function will return a #VALUE! error.

Syntax

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

The NUMBERVALUE function has the following arguments:

Argument	Description
text	The text data that represents a number.
decimal_separator	The character used to separate the integer and fractional part of the result. It is an optional argument. If it is omitted, the current locale is used.
group_separator	The character used to separate groupings of numbers, such as thousands from hundreds and millions from thousands. It is an optional argument. If it is omitted, the current locale is used.

Notes

How to apply the NUMBERVALUE function.

Examples

The figure below displays the result returned by the NUMBERVALUE function.