VALUE function
Summary
Converts a text argument to a number
Syntax
VALUE(text)
The VALUE function syntax has the following arguments:
• Text Required. The text enclosed in quotation marks or a reference to a cell containing the text you want to convert.
• Text Required. The text enclosed in quotation marks or a reference to a cell containing the text you want to convert.
Example
=VALUE("$1,000")
=VALUE("16:48:00")-VALUE("12:00:00")
=VALUE("16:48:00")-VALUE("12:00:00")