Referencing a cell on another worksheet within the same workbook

L

Louie Warren

I used to do this:
=worksheetname!cellID
and the value of the cell on the other sheet "magically"
appeared in the new worksheet. Now, it just shows the
formula as text. I've fixed this before, but I'm having
brain flatulence... can someone enlighten me?

Excel 2000 BTW...

L
 
D

Dave Peterson

Format the formula cell as General,
then hit F2 and then enter.

Excel tries to help by copying over the numberformat from the "sending" cell. I
bet you editted the cell one time (even just F2, enter will do it).

That's where the magic started.
 
L

Louie Warren

That did it! Thanx!
-----Original Message-----
Format the formula cell as General,
then hit F2 and then enter.

Excel tries to help by copying over the numberformat from the "sending" cell. I
bet you editted the cell one time (even just F2, enter will do it).

That's where the magic started.




--

Dave Peterson
[email protected]
.
Click to expand...
 
Top