Home   Back   Next  

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





Return Value


VAL() returns a numeric value 





VAL("12.085") = 12.085 


VAL("-10") = -10 


VAL("5548A") = 5548 


VAL("5548A-12345") = 5548 


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