VALUE
Converts a textual number representation to a number.
Syntax
=VALUE(Text, Locale)
Arguments
| Name | Type | Description |
|---|---|---|
| Text | String | A string representing a number value. |
| Locale | String | An optional locale code. Currently only "en" and "de" are supported. Default value: "Application Locale" |
Return
A number or #VALUE! if given Text cannot be converted.
Examples
| Formula | Result | Comment |
|---|---|---|
| 22.45 | |
| 22,45 | |
| #VALUE! |