VALUE ER function

The VALUE function returns a Real value that is converted from the specified string.

Syntax

VALUE (text)

Arguments

text: String

A string value that must be converted to a numeric value.

Return values

Real

The resulting numeric value.

Usage notes

Commas and dot characters (.) are considered decimal separators, and a leading hyphen (-) is used as a negative sign. An exception is thrown at runtime if the specified string contains other non-numeric characters.

Example 1

VALUE ("1 234,56") throws an exception.

Example 2

VALUE ("1234,56") returns 1234.56.

Additional resources

Type conversion functions