Spread Formula Reference
Formula Functions / Functions T to Z / VALUE
In This Topic
    VALUE
    In This Topic

    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