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

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" <(E-Mail Removed)> wrote in message
news:956063DA-A71F-426A-BCF1-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:956063DA-A71F-426A-BCF1-(E-Mail Removed)...
> > 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
>
>
>

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
<(E-Mail Removed)> 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