Formula appears instead of value

P

Pat

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
 
C

Chip Pearson

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
 
P

Pat

Thanks Chip that sorted it!
Pat


Chip Pearson said:
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
Click to expand...
 
Top