Cell reference returning cell name instead of value
 

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?

Cell reference returning cell name instead of value
 

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?