Formula is entered but will not display result

  • Thread starter Thread starter webee33
  • Start date Start date
W

webee33

This is elementary, I think, and I know it's happened to me before but I
can't remember what the problem was. I have a simple formula:

='Different Worksheet'!$R13

The formula is copied on several worksheets, and I need to go through
and update the row number. It displays the result of the above until I
change the row number, and then it displays the actual formula instead
of the result. Any idea why it won't pull the result??

Perplexed,
Amy
 
1. clear the cell
2. format the cell as general (not text)
3. re-type the formula (not paste)

Excel may be treating your formula as a text string.
 
You must log in or register to reply here.

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

formula displays as a formula, not as its result 1
E2007 formulas display as formulas, not results 3
Excel VBA 1
vLookup returns formula and not result 4
Formula results display only after pressing Enter key 1
Worksheet Names using Macros 5
Counting Results of Formulas 1
Why does forumula show in cell instead of formula result? 2

Back
Top