1 year ago

#379589

test-img

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

Accepted video resources