Hi all,
Can someone tell me if there is a sheet function which reacts the same as
VAL("T6") = 0, VAL("6T") = 6, VALUE will produce an error?
? VAL("6T")
6
? VAL("T6")
0
=VALUE("6T")
#VALUE!
=VALUE("T6")
#VALUE!
Eventualy I would like to see if a cell contains a number or text.
Thx,
Ludovic
Bookmarks