All functions / Text
VALUE
Converts text that looks like a number into a number.
Syntax
=VALUE(text)
Arguments
text: The text (or a cell containing it).
Example
=VALUE("42") → 42
All functions / Text
Converts text that looks like a number into a number.
=VALUE(text)
text: The text (or a cell containing it).=VALUE("42") → 42