Formula appears instead of value
 

What would cause a formula to display instead of the result.
For example in sheet1 A1 if I enter =Sheet2!A1 I will get =Sheet2!A1
displayed in the cell.


I should point out this problem does not occur if I select a different range
on the same sheet.

Hope you can understand what my problem is!
Pat

Most likely the cell is formatted as Text. Change the format to
General, and press F2 then Enter.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Pat" wrote in message
...
What would cause a formula to display instead of the result.
For example in sheet1 A1 if I enter =Sheet2!A1 I will get
=Sheet2!A1
displayed in the cell.


I should point out this problem does not occur if I select a
different range
on the same sheet.

Hope you can understand what my problem is!
Pat

Thanks Chip that sorted it!
Pat


"Chip Pearson" wrote in message
...
Most likely the cell is formatted as Text. Change the format to
General, and press F2 then Enter.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Pat" wrote in message
...
What would cause a formula to display instead of the result.
For example in sheet1 A1 if I enter =Sheet2!A1 I will get
=Sheet2!A1
displayed in the cell.


I should point out this problem does not occur if I select a
different range
on the same sheet.

Hope you can understand what my problem is!
Pat