worksheet reference returns address instead of value

P

pobruce

I'm "pointing to" a cell in another worksheet. I should be able to hit "="
then click on the worksheet and cell I want, then hit enter. The value in
the referenced cell should now show in the new worksheet. Instead, I'm
seeing the address of the referenced cell.

Has anyone had this problem? Is there possibly something in the formatiing
of the two worksheets that's causing a problem?
 
N

Niek Otten

The cell was probably formatted as text before you entered the formula.
Format as general *and re-enter the formula* (F2, ENTER)
 
G

Gord Dibben

I'm guessing that the cell you are entering the "=" sign into is formatted as
text.

Re-format to General and try again.

OR you have "View Formulas" enabled.

Hit CTRL + `(backquote above Tab key) to toggle on/off.


Gord Dibben MS Excel MVP
 
Top