NUMBERVALUE(text [,decimal_separator] [,group_separator])

Returns the number that a text string represents (current locale).

textThe text string you to want converted to a number.
decimal_separator(Optional) The character used to separate integer and fraction.
group_separator(Optional) The character used to separate thousands and millions.

Remarks

* Added in Excel 2013.
* This function replaces the VALUE function.
* If "decimal_separator" is left blank, then the current locale is used.
* If "group_separator" is left blank, then the current locale is used.
* If the "group_separator" occurs before the decimal separator, the group separator is ignored.
* If the "group_separator" occurs after the decimal separator, then #NUM is returned.
* If "text" contains any spaces, they are ignored.
* If "decimal_separator" contains more than 1 character, only the first character is used.
* If "group_separator" contains more than 1 character, only the first character is used.
* For the Microsoft documentation refer to support.office.com

 A
1=NUMBERVALUE("2^500.27",".","^") = 2500.27
2=NUMBERVALUE("3.5%") = 0.035
3=NUMBERVALUE("10%%") = 0.001

1 - This converts a text string which has a decimal character represented by a "^" and a group separator character represented by a ",".
2 - This converts a text string using the current locale characters
3 - This calculates the percentage twice.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top