![]() |
#2
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
excel help Formula | sellspeed | Excel | 15 | 03-10-2010 10:57 AM |
![]() |
Corca | Excel | 6 | 02-22-2010 09:40 PM |
![]() |
sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |
Help for formula | dehann | Excel | 5 | 05-01-2009 10:44 AM |
![]() |
tinkertron | Excel | 11 | 04-16-2009 11:43 PM |