NUMBERVALUE

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
* 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.
* You can use the DATEVALUE function to return the date serial number for a date in text format.
* You can use the TIMEVALUE function to return the time as a decimal given a time in text format.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com

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

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.

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