How to Use VALUE Function

The VALUE function is to convert a text string that stands for a number into a number.


= VALUE(text)


–Text is required, the text string that you need to covert.


– 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".

Download: Value Function

Leave a Reply