If I do
This works for numbers 1-9 but not 0.
How would I write a function that returns 'string is numeric' for '0' but 'string is not numeric for 'A'?
I suppose I could do:
Code
if val(mystring) > 0
or
if val(mystring) = 0
and mystring = "0"
string is numeric
else
string is not numeric
Display More
but that's a bit complicated. Any better ideas?