Excel 2003

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

Guest

I have enetered a link to another worksheet cell, say in cell C2: =Sheet2!A1.
The result in C2 indicates the formula (=A1) and not the answer of A1. Note
that all the other cells in the worksheet has formulas and return the answers
and the Tool/Options/View/Formulas tab is unticked
 
The cell is probably formatted as text. delete the formula, format as general
and re-enter the formula.

Mike
 
100% fixed - thank you, Mike

Mike H said:
The cell is probably formatted as text. delete the formula, format as general
and re-enter the formula.

Mike
Click to expand...
 
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

Excel VBA 1
Excel Need Countifs Formula Help 0
Excel Moving data to sheet2 from sheet1 0
LOOKUP function different? 2
Cell reference not populating 1
Extremely slow calculation of formulas 4
VBA Countif across sheets? 5
Formula Locking? 1

Back
Top