VALUE

Converts text that appears in a recognized format (e.g. a number, date, or time format) into a numeric value.

Parameter List

Syntax
VALUE(text)
text

The string containing the value to be converted. For example: “123.

Examples

VALUE(3%) returns 0.03