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 Spreadsheet for WPF. 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