VALUE function
VALUE converts a text string into a number.
Syntax
VALUE (text)
text is the text to be converted to a number.
Example
=VALUE("4321") returns 4321.
Note: If
the text string cannot convert to a number, VALUE returns #VALUE!.
VALUE converts a text string into a number.
VALUE (text)
text is the text to be converted to a number.
=VALUE("4321") returns 4321.