VALUE

Converts the specified text that represents a number to a number.

Syntax

VALUE( Text text ) → Number

Parameters

text

Required. The text to convert.

Remarks

The text argument can be in any number, date, or time formats recognized by <variable not found>. If text is not in one of these formats, VALUE returns the #VALUE! error value. If text is an empty text, the return value is 0.

Example

Formula

=VALUE("$1,000")
=VALUE("1/1/5")

See Also

Function Reference
N Function
T Function
TEXT Function