- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Statistical - NUMBERVALUE Function
Description
The NUMBERVALUE function converts text to a number, in a locale-independent way.
Syntax
NUMBERVALUE (Text, [Decimal_separator], [Group_separator ])
Arguments
Argument | Description | Required/ Optional |
---|---|---|
Text | The text to convert to a number. | Required |
Decimal_separator | The character used to separate the integer and fractional part of the result. | Optional |
Group_separator | The character used to separate groupings of numbers, such as thousands from hundreds and millions from thousands. |
Optional |
Notes
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%%.
Applicability
Excel 2013, Excel 2016