The VALUE function is to convert a text string that stands for a number into a number.
Formula:
= VALUE(text)
Explanations:
–Text is required, the text string that you need to covert.
Cautions:
– Text string standing for a number can be a date, a time or any numbers with the text format.
Example: what is the number value of "1/17/2012" and "10:30am"?
=VALUE(A2), the result returns 40,925;
=VALUE(A3), the result returns 0.4375.
The text "1/17/012 10:30am" returns to 40925.4375, a combination of "1/17/2012" and "10:30 am".