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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing a cell from another worksheet 3
referencing a cell in another worksheet 5
Code to format cells on several worksheets 2
Link one worksheet in a workbook to another worksheet in same work 1
Sharing workbooks limitations - Merged Cells 12
Formulas referencing different sheets in workbook 1
Creating A List of Items Between Two Numbers 2
Go to another cell on another worksheet 2

Back
Top