Formula appears instead of value

  • Thread starter Thread starter Pat
  • Start date Start date
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
 
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
 
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...
 
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

If formula-different numbers entries 2
Blank instead of 0 1
bookkeeping-payment confirmation 7
Lookup and count in the same formula 1
Can I sort and not lose reference to the cell? 3
Help! I am having a problem with sort! 2
Code to format cells on several worksheets 2
numbers instead if text 2

Back
Top