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.
Starting with 2.31, this function will also attempt to recognise date values, and numbers with currency and thousands separator characters.