Formula Display

  • Thread starter Thread starter Kimbanev
  • Start date Start date
K

Kimbanev

Sometimes a cell's formula displays on my worksheet instead of the
calculation. Why does this happen, and how can I fix it? I've tried
re-formatting the cell, but this does not fix the problem.
 
Go to tools/options and click on the "view" tab. Make sure that in window
options at the bottom "Formulas" is unticked.
 
It is unticked, but the formula still appears. Control and back apostrophe
(to the left of the 1 on the keyboard) does not work either. Thanks for
trying.
 
If the cause of your problem is a cell formatted as Text, then after
reformatting the cell to General (or something other than Text), you'll need
to re-enter the formula.
 
I think you have to re-enter the formula *after* you reformat the cell.

Rick
 
It is just a fun!!
It happened with me also earlier.

it is because you have unknowingly pressed the shortcut key

Control + ~

[control + Tilde ]

it is a toggling key
 
I have had the same problem for the last 2 days. In Excel 07, Ctrl` does not
work to toggle between the formula and the result.
I changed the cell from Text to General and re-entered the formula.
That worked!
Eric
 

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

Why does forumula show in cell instead of formula result? 2
Excel VBA 1
Formulas displayed in cell rather than calculated values? 4
E2007 formulas display as formulas, not results 3
Cell shows the last typed text, no matter where it is typed 0
formula displays as a formula, not as its result 1
Help needed 0
Excel Stop Excel from displaying rounded values 4

Back
Top