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

Example

NUMBERVALUE Function
advanced_excel_statistical_functions.htm
Advertisements