Spread Formula Reference
Formula Functions / Functions M to Q / NUMBERVALUE
In This Topic
    NUMBERVALUE
    In This Topic

    This function converts text to a number, in a locale-independent way.

    Syntax

    NUMBERVALUE(text, decseparator, groupseparator)

    Arguments

    This function has these arguments:

    Argument Description
    text Text to convert to a number
    decseparator [Optional] Character used to separate the integer and fractional part of the result
    groupseparator [Optional] Character used to separate groupings of numbers

    Remarks

    If the separator arguments are not specified, separators from the current locale are used. The result is 0 if an empty string is specified as the text argument. The #VALUE! error value is returned if the group separator occurs after the decimal separator in the text argument.

    Data Types

    Accepts string data. Returns numeric data.

    Examples

    NUMBERVALUE("2.4%") gives the result 0.024

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.