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.
56