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" wrote in message
...
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.