# NUMBERVALUE

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



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.