2

Can anyone please help tell me why below expression in immediate box shows the result as True?

? IsNumeric("1d11")

? IsNumeric("5000d110")

Thank you. Lei

Zhou Lei
  • 23
  • 6
  • 2
    These numbers are both valid [hexadecimal](https://en.wikipedia.org/wiki/Hexadecimal) numbers. Use `If VarType(Evaluate("5000d110")) = vbDouble` to check whether a string is a valid base 10 number. – Florent B. Oct 08 '17 at 18:25
  • Thank you Florent, this make perfect sense and solution. :) – Zhou Lei Oct 08 '17 at 19:28

1 Answers1

2

Both of these values are valid hexadecimal numeric values. That is why the result is true.

xZ6a33YaYEfmv
  • 1,816
  • 4
  • 24
  • 43