Does it matter that some of the numbers are 8 digits, some are 8 with a hyphen and another number etc.?

I tried changing it to a semicolon instead of comma but it didn't like that. Tried it again with a comma and it returned some "true" values this time but not the correct ones. Other thing I am wondering is if maybe some of the cells aren't formatted right? I notice a few of them have the "comment" icon and it says "this number is formatted as text or proceeded by an apostrophe". Is there an easy way to make sure those are all correct and eliminate that as a possible problem?