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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for