This article describes the formula syntax and usage of the NUMBERVALUE function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.
Converts text to a number, in a locale-independent way.
NUMBERVALUE(Text, [Decimal_separator], [Group_separator ])
The NUMBERVALUE function syntax has the following arguments.
- Text 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.
- If the Decimal_separator and Group_separator arguments are not specified, separators from the current locale are used.
- If multiple characters are used in the Decimal_separator or Group_separator arguments, only the first character is used.
- If an empty string ("") is specified as the Text argument, the result is 0.
- Empty spaces in the Text argument are ignored, even in the middle of the argument. For example, " 3 000 " is returned as 3000.
- If a decimal separator is used more than once in the Text argument, NUMBERVALUE returns the #VALUE! error value.
- If the group separator occurs before the decimal separator in the Text argument , the group separator is ignored.
- If the group separator occurs after the decimal separator in the Text argument, NUMBERVALUE returns the #VALUE! error value.
- If any of the arguments are not valid, NUMBERVALUE returns the #VALUE! error value.
- If the Text argument ends in one or more percent signs (%), they are used in the calculation of the result. Multiple percent signs are additive if they are used in the Text argument just as they are if they are used in a formula. For example, =NUMBERVALUE("9%%") returns the same result (0.0009) as the formula =9%%.
The workbook below shows examples of this function. Inspect them, change existing formulas, or enter your own formulas to learn how the function works.
To work more in-depth with the example data in Excel, download the embedded workbook to your computer, and then open it in Excel.
Top of Page