Skip to main content
Windward

NUMBERVALUE Function

Overviewautotag-wiki-logo.png

The NUMBERVALUE function

Converts text to a number, in a locale-independent way.

For example

=NumberValue(\"12.00,0\",\",\",\".\") returns 1200

Syntax

NUMBERVALUE(text,Decimal_separator,Group_separator)
  • ​number - 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.
  • Was this article helpful?