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))  



ADVERTISEMENT
ADVERTISEMENT