NUMBERVALUE Function Explained
The NUMBERVALUE Function in Microsoft Excel converts a text string that represents a number to a number. It takes two arguments: text and decimal_separator. The text argument is the text string that you want to convert to a number, and the decimal_separator argument is the character used to separate the integer and fractional parts of the number. The NUMBERVALUE Function is useful when you need to convert a text string that represents a number to a number that can be used in calculations.
NUMBERVALUE Function Syntax
NUMBERVALUE(text, [decimal_separator], [group_separator])
- text: The text string that you want to convert to a number.
- decimal_separator: (Optional) The character used to separate the integer part from the fractional part of the number. The default is a period (.).
- group_separator: (Optional) The character used to separate groups of digits to the left of the decimal separator. The default is a comma (,).