It sounds like the cell is formatted as Text. Change the format for the cell
to General and reenter the formula.

Rick

"jefeweiss" wrote in message
...
I am using Excel 2002. I have a cell on a worksheet that is supposed to
pull
my name from a data entry worksheet. So I press = select the field with
my
name on it from the data entry worksheet and press return. Instead of
returning the value of the field (my name) it returns "='Data Entry'!B7"
This same field will not return a value for any field that I select. The
field directly below it returns my name when pointed at the name field on
my
data entry sheet.

How can I fix this field so it returns the right value?