Search code examples
vbaisnumeric

VBA IsNumeric fails on specific strings?

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

? IsNumeric("1d11")

? IsNumeric("5000d110")

Thank you. Lei

Solution

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