# VALUE

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 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](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionDOLLAR) \| [DOLLARFR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionDOLLARFR) \| [FIXED](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionFIXED) \| [Text Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functstext)