VALUE

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.