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" 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.