Description
NUMBERVALUE is a text function in Excel. Use it to convert a number in text format to number. Having three arguments where first one is mandatory and other two are optional. In first argument text you need to give number in text format you want to convert, second is Dcimal_seprator and last is Group_separator.
Syntax
NUMBERVALUE(Text, [Decimal_separator], [Group_separator ])
Example
- In the number in text format comma(,) is used as decimal separator and period(.) as group separator
- NUMBERVALUE ignore the space between the digits
- NUMBERVALUE converts the number by calculating percentage
- NUMBERVALUE returns #VALUE! Error, if decimal seprator is used more than once
- NUMBERVALUE returns #VALUE! Error, if group separator appear after decimal separator
0 Comments