Excel VALUE() Function
The VALUE() function in excel converts the specific text representing a number (i.e., a number, date, or time format) into a numerical value.
Syntax
VALUE(Text)
Parameter
Text(required)- This parameter represents the string that you want to convert to number.
Category
Text
Return
The function returns the number value by converting the text value into a numeric value.
Example 1
Objective: Convert the values into numbers by using VALUE() Function
Text | Result | Formula |
$189,845 | 189845 | =VALUE(A15) |
7/2/2017 | 42918 | =VALUE(A16) |
1/19/2011 | 40562 | =VALUE(A17) |
Example 2
Objective: Get the sum of dummy values and convert the given text representation of the number into value.
Dummy Value | Result/ Sum | Formula |
23579 76854 68956 78643 | 248032 | =SUM(VALUE(D121:D124)) |