Spread Formula Reference
VALUE
Formula Functions > Functions T to Z > VALUE

This function converts a text string that is a number to a numeric value.

Syntax

VALUE(text )

Arguments

This function has these arguments:

Argument Description
text Number in quotation marks or a reference to a cell with the text.

Remarks

The text can be in number, date, or time format. If the text is not in the correct format, a #VALUE! error is returned.

Data Types

Accepts string data. Returns numeric data.

Examples

VALUE("$9,000")gives the result 9000

Version Available

This function is available in product version 3.0 or later.

See Also

DOLLAR | DOLLARFR | FIXED | Text Functions