Data is very often displayed differently than it is stored... formatting can only change the appearance of data; formatting is not capable of changing values.
To see the true contents of a cell, select the cell and look at the Formula bar (wide white thing above the column letters). I suspect cell A2 is lying to you.
|