referencing a cell in another worksheet

S

Shannan

Hi,
I want cell F55 in worksheet "January" to display what is typed in cell B6
of worksheet "Sheet 1". These two worksheets are in the same workbook. I've
typed "=Sheet1!B6" in cell F55, but instead of displaying "Jan. 4" which is
what is typed into cell B6 it is showing me the forumla that i typed. What am
i doing wrong/ how do i fix this?
 
J

Jim Thomlinson

If the format of the cell you put the formula in is text then it will dispaly
the formula an not it's result. Change the Format of the cell from Text to
General (or some other format). Now double click on the cell and press
enter...
 
S

Shannan

*gasp!* Thank you!

Jim Thomlinson said:
If the format of the cell you put the formula in is text then it will dispaly
the formula an not it's result. Change the Format of the cell from Text to
General (or some other format). Now double click on the cell and press
enter...
 

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

Top