Referencing a cell on another worksheet within the same workbook

  • Thread starter Thread starter Louie Warren
  • Start date Start date
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
 
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.
 
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
(e-mail address removed)
.
Click to expand...
 
Back
Top