# NUMBERVALUE

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

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

 text The 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 characters3 - This calculates the percentage twice.