VALUE
Converts a text argument to a number
Syntax
VALUE(text)
Parameters
- 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")Converts a text argument to a number
VALUE(text)
=VALUE("$1,000")