In Excel 2013 or 2010, if you put this value in column B1:
And then this formula in column C1:
The formula will evaluate to 1. But the numbers are different: the one in the formula ends with a 9, the one in the cell ends with a zero.
countif match a value it shouldn't? Is there a workaround available?