Link to Cell Not Updating

[Guest]

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 !
---------------------------------------------------------------------------

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

 

[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

--

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.