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.
Accepts string data. Returns numeric data.
NUMBERVALUE("2.4%") gives the result 0.024
This function is available in Spread for Windows Forms 11.0 or later.