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

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


    NUMBERVALUE(text, decseparator, groupseparator)


    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


    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.


    NUMBERVALUE("2.4%") gives the result 0.024

    Version Available

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