A and B are not cells................they are columns.

Cells are like A1 or B1

What is the incorrect value you get and what do you think it should be?

Could you post your formula?

Sounds like maybe you have numbers that are formatted as text.

You could try to select all cells and re-format to General.

Now select an empty cell and copy it.

Select the cells with numbers................not formulas............and
paste specialaddokesc

Do formula now calculate?

Another trick is to to select all and EditReplace

What: = sign

With: = sign

Replace all.


Gord Dibben MS Excel MVP

On Wed, 8 Apr 2009 11:11:02 -0700, JohnOC
wrote:

Hello,
I have a cell (cell A) on one tab referencing a cell on another tab (cell
B), but returning an incorrect value. Is there a way to fix this on a
wholescale level. It was not a calculation problem (tried F9). I was able
to fix the problem by putting the cursor at the end of the formula in cell A
and hitting enter, but this could be happening throughout the spreadsheet.
Any advice or help is greatly appreciated.

Thank you,

John