Excel 2003

J

Johan

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
 
M

Mike H

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

Mike
 

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

complicated excel formula may need an algebra wiz 1
Option Group & Other Worksheet 0
Excel Formula question 0
A find formul looking at two named ranges for two strings 8
Can a formula do this? 1
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Embed the same Excel multiple times 0
Show a cell's formula in text format in a linked cell 2

Top