Forum Discussion
aallman
Helper II
Helper IIWhy does the formula VALUE("2a") return 0.0833333 ?
In my table, "2a" is a character string. I would assume that would mean putting it in the VALUE function would return an ERROR but actually it returns 0.0833333. Does anyone know why??
Yes the other solution worked for me, thank you! I was just curious about why exactly the "a" was allowed to be converted to a number. Thanks again!
amitchandak
Super User
Super Useraallman , Refer doc, what all can happen with text datatype
- AlexisOlson
See also this documentation including relevant examples related to time:
