Cell reference returning cell name instead of value

[Guest]

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?

 

[Rick Rothstein \(MVP - VB\)]

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

Rick