Jayesh,

Notice that Robert has a '12s2' string which would return a value of 12
if you are using the VAL() function.

Actually Alan's answer would be a better way to go.


>Use VAL() function. VAL() returns zero if string is passed. You will have to check if the variable contains zero string. e.g. "0" or "0.00" etc.