Zhou Lei
Reputation: 23
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
Upvotes: 2
Views: 118
Answers (1)
xZ6a33YaYEfmv
Reputation: 1816
Both of these values are valid hexadecimal numeric values. That is why the result is true.
Upvotes: 2
Related Questions
- VBA isString vs isNumeric
- How do I make IsNumeric check the whole string/variable instead of just the first character?
- how to check if a string contains only numeric numbers in vba
- If IsNumeric(num) And Len(num) > 1 evaluates false for a number?
- VBA - Why IsNumeric is not evaluating correctly
- VBA IsNumeric going WILD
- IsNumeric/IsError returns an error
- EXCEL VBA : How to validate value with isString or isNumeric?
- IsNumeric true but should be false
- Am I using the isnumeric function correctly?