Converts text into a number, including converting formatted strings like date or date-time.
Sample Usage
VALUE(A1)
VALUE("1/1/2010")
Syntax
VALUE(text)
- text - The text, date, or time string to convert into a number
Examples
VALUE(A1) converts the value in cell A1 into a number.
VALUE("1/1/2010") converts the date string "1/1/2010" to the number 40179.