Val()

Working with Formulas > Functions Used in Formulas > Conversion Functions > Val()

VAL() converts a character expression to a numeric format. It is the opposite of the function STR().

NOTE: If VAL() encounters any non-numeric related characters, it stops converting the expression at that point. If this happens before VAL() has come to the numeric part of the string, then it returns 0.

Function Format

VAL(string) 

Return Value

VAL() returns a numeric value 

Examples

VAL("12.085") = 12.085 

VAL("-10") = -10 

VAL("5548A") = 5548 

VAL("5548A-12345") = 5548 

VAL("A-5548-12345") = 0