VALUE.NUMBER function

Category:Text

What does the VALUE.NUMBER function do?

The VALUE.NUMBER function converts text to number independently of locale.

Availability

  • Excel for Office 365: Yes
  • Excel 2016: Yes
  • Excel 2013: Yes
  • Excel 2010: No
  • Excel 2007: No
  • Excel 2003: No

Translations

Syntax

VALUE.NUMBER (Text, Decimal_separator , Group_separator )

  • Text (required ): It is the string that represents the number you want to convert.
  • Decimal_separator (optional ): It is the character that is used as a decimal separator in the string.
  • Group_separator (optional ): It is the character that is used as the group separator in the string.

Important remarks about the VALUE.NUMBER function:

  • If the decimal_separator and group_separator arguments are not used, then the default separators in the regional settings of the computer will be used.
  • If multiple characters are entered in the Decimal_separator or Group_separator arguments, only the first character will be used.
  • If the Text argument is an empty string, then the result will be 0 (zero).
  • Whitespace within the Text argument, either at the ends or in the middle of the text string, will be ignored.
  • If the Text uses the decimal separator multiple times, the function will return the #VALUE! Error.
  • If the Group_separator character appears before the Decimal_separator, the Group_separator will be ignored.
  • If the Group_separator character appears after the Decimal_separator, the function will return the error #VALUE!
  • If any of the arguments are invalid, the function will return the #VALUE! Error.

Leave a Comment