Excel not recognizing values as equal

[davegugg]

Hi

I have a spreadsheet which is exported by a vendor's software. This spreadsheet has a column of numbers, but I can't consistently work with them in vba. It seems like some of them are not recognized as numbers.

As an example, I've stripped the sheet of all data except the column of numbers. Next I've set up a simple formula. Please see if you can make sense of why the formula returns "Not Equal". Changing the cell format does not help, and I also find it odd that if I set the cell format to number, changing the number of decimal places displayed does not effect what is shown in the cell.

Thanks