Cell reference returning cell name instead of value

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
It sounds like the cell is formatted as Text. Change the format for the cell
to General and reenter the formula.

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Use cell contents to build sheet reference 5
VLOOKUP - Return value of the cell below the formula's answer 1
Vlookups and formats 3
Worksheet Linking problem 6
Pivot Table - Cell Value 2
worksheet reference 6
Looking up a returned value defining a named range 2

Back
Top