Data from another cell
 

Does anyone know why when I use the equal (=) sign to get data from another
cell in another worksheet it just gives me the cell name: i.e. =targetdateC2.
and not the actual data which is 2x. I tried manually calculating to no
extent.

Thanks
Frank

Data from another cell
 

Is the cell formatted as Text? Try changing the format to General.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Beep Beep" wrote in message
...
Does anyone know why when I use the equal (=) sign to get data from
another
cell in another worksheet it just gives me the cell name: i.e.
=targetdateC2.
and not the actual data which is 2x. I tried manually calculating to no
extent.

Thanks
Frank

Data from another cell
 

Thanks Bob

Learn something new everyday

Frank

"Bob Phillips" wrote:

Is the cell formatted as Text? Try changing the format to General.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Beep Beep" wrote in message
...
Does anyone know why when I use the equal (=) sign to get data from
another
cell in another worksheet it just gives me the cell name: i.e.
=targetdateC2.
and not the actual data which is 2x. I tried manually calculating to no
extent.

Thanks
Frank

Data from another cell
 

If you are manually entering the formula you need the ! inserted.

=targetdate!C2

If you are letting Excel enter the reference it should be no problem.

Enter the = sign then switch to other sheet, select C2 and hit ENTER key


Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 08:12:05 -0700, Beep Beep
wrote:

Does anyone know why when I use the equal (=) sign to get data from another
cell in another worksheet it just gives me the cell name: i.e. =targetdateC2.
and not the actual data which is 2x. I tried manually calculating to no
extent.

Thanks
Frank