1 year ago
#379589
David Anderson
My VBA is treating the letter D as a number, what is going on?
I typed ?IsNumeric(1974D01)
into my immediate window and I got this response
?isNumeric(1974D01) True
What is going on? Why is the IsNumeric()
function not working properly? I have tried multiple letter and number combos and all that I have found is that if I have a number and then followed by a singular "D" followed by other numbers it creates an issue. Has anyone experienced this before?
excel
vba
string
numbers
0 Answers
Your Answer