| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
referencing a cell in another worksheet
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
referencing a cell in another worksheet
you might have pressed Ctrl+~ key. Try pressing it again.
-- Karthi "Shannan" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
referencing a cell in another worksheet
Nope, i hadn't pressed that.
"Karthik" wrote: you might have pressed Ctrl+~ key. Try pressing it again. -- Karthi "Shannan" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
referencing a cell in another worksheet
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... -- HTH... Jim Thomlinson "Shannan" wrote: 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
referencing a cell in another worksheet
*gasp!* Thank you!
"Jim Thomlinson" wrote: 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... -- HTH... Jim Thomlinson "Shannan" wrote: 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
referencing a cell in another worksheet
format as Date as opposed to Text?
Shannan wrote: Nope, i hadn't pressed that. "Karthik" wrote: you might have pressed Ctrl+~ key. Try pressing it again. -- Karthi "Shannan" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a cell from another worksheet | Excel Discussion (Misc queries) | |||
| Referencing a cell in another worksheet within the same workbook | Excel Worksheet Functions | |||
| Referencing a cell to another worksheet | Excel Discussion (Misc queries) | |||
| Referencing a worksheet name to a cell... | Excel Worksheet Functions | |||
| Referencing another worksheet via a cell | Excel Worksheet Functions | |||
Linear Mode
