Syntax :

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

Parameters :

• The following parameter are:

text –

• The text string to be converted to a number.

[decimal separator] –

• An optional parameter indicating the character that separates the provided number’s integer and decimal parts.
  When [decimal separator] is not specified, the separator from the current locale is used.

[group separator] –

• An optional parameter that specifies the character used to divide groups (e.g. thousands, millions, etc.).
  When [group separator] is not specified, the separator from the current locale is used.