VALUE

Converts an expression to a number format, if possible.  Automatically converts arguments to functions as needed.

Syntax

VALUE(expression)

Arguments

expression

Text, number, or cell reference to convert to number format.

Example

VALUE("100"+".50") returns the value 100.5.