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.