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