View Single Post
 
Old 06-09-2010, 12:59 PM
Kimberly Kimberly is offline Windows 7 Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

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.
Reply With Quote