Converts a text string to a number wherever possible.
Syntax:
VALUE(text)
If text is not convertible to a number, but to text or to a date, zero is returned.
Example:
VALUE("56")
returns the number 56
.
Revisions:
Starting with 2.24, this function can accept text strings longer than 200 characters as input.