In Excel 2013 or 2010, if you put this value in column B1:

```
2014022701000400
```

And then this formula in column C1:

```
=COUNTIF(B1,"2014022701000409")
```

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.

Why does `countif`

match a value it shouldn't? Is there a workaround available?