Hi

check that calculation is set to automatic (tools / options / calculation -
automatic) if that is not the problem could you explain in a bit more detail
what you mean by:
"others show 0 even though when you look at the cell contents it shows it
being equal
to the other cell correctly."

how are you "looking at the cell contents"?

Cheers
JulieD


" wrote
in message ...
We have a large worksheet with the cells in one column equal to the cells
in
a different column. Some of the cells display the results correctly,
others
show 0 even though when you look at the cell contents it shows it being
equal
to the other cell correctly.