Link to Cell Not Updating

[Jason]

Having a problem I've never seen, and can't figure it out. In Cell A1 I have
some text (assume it is "boy"). In Cell A2 I want to reference the value in
A1, so when A1 changes, A2 changes along with it. In Cell A2 I have the
formula "=A1". Instead of returning "boy" in A2, it just shows =A1 in the
cell, and doesn't catch the link. I've tried to force calc and have ensured
calculation is set to auto, cell still just shows =A1. Any ideas? Thanks.

[Ragdyer]

Cell (A2) is probably formatted as text.

Format to General and re-enter.

You can select A2, then:
<Ctrl> <Shift> < ` > (under the <Esc> key - some keyboards it's lower ~)
Then
<F2> <Enter>.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jason" <Jason@discussions.microsoft.com> wrote in message
news:7BEE7FA0-7319-41FA-907F-BAC8D4100C95@microsoft.com...
> Having a problem I've never seen, and can't figure it out. In Cell A1 I
have
> some text (assume it is "boy"). In Cell A2 I want to reference the value
in
> A1, so when A1 changes, A2 changes along with it. In Cell A2 I have the
> formula "=A1". Instead of returning "boy" in A2, it just shows =A1 in the
> cell, and doesn't catch the link. I've tried to force calc and have
ensured
> calculation is set to auto, cell still just shows =A1. Any ideas?
Thanks.

[Biff]

Hi!

Cell A2 is probably formatted as TEXT.

Select A2 and set the format to GENERAL.

With A2 still selected hit function key F2 then hit ENTER.

Biff

"Jason" <Jason@discussions.microsoft.com> wrote in message
news:7BEE7FA0-7319-41FA-907F-BAC8D4100C95@microsoft.com...
> Having a problem I've never seen, and can't figure it out. In Cell A1 I
> have
> some text (assume it is "boy"). In Cell A2 I want to reference the value
> in
> A1, so when A1 changes, A2 changes along with it. In Cell A2 I have the
> formula "=A1". Instead of returning "boy" in A2, it just shows =A1 in the
> cell, and doesn't catch the link. I've tried to force calc and have
> ensured
> calculation is set to auto, cell still just shows =A1. Any ideas?
> Thanks.

[Max]

Cell A2 could have (inadvertently) been formatted as Text
Re-format A2 as General (via: Format > Cells),
then re-enter the formula in A2
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jason" <Jason@discussions.microsoft.com> wrote in message
news:7BEE7FA0-7319-41FA-907F-BAC8D4100C95@microsoft.com...
> Having a problem I've never seen, and can't figure it out. In Cell A1 I
have
> some text (assume it is "boy"). In Cell A2 I want to reference the value
in
> A1, so when A1 changes, A2 changes along with it. In Cell A2 I have the
> formula "=A1". Instead of returning "boy" in A2, it just shows =A1 in the
> cell, and doesn't catch the link. I've tried to force calc and have
ensured
> calculation is set to auto, cell still just shows =A1. Any ideas?
Thanks.