Formula result not appearing in Cell

G

Guest

After I have entered a formula into a cell, the formula appears not the
result. When I check the formula it shows the correct result but does not
appear in the cell. I have tried it with different formulas, even very easy
ones, with the same results. This also does not happen in all cells. I
copied the formula to a cell above the one I wanted it in and it worked fine.
What is causing the formula to appear in the cell instead on the result?
 
G

Gord Dibben

Most common reason is the cells are pre-formatted as Text.

Select a "bad" cell and F2 and ENTER


Gord Dibben MS Excel MVP
 

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
formula displays as a formula, not as its result 1
Excel VBA 1
Offset a formula result 1
formula errors 2
Show the formula not the result 3
Cell reference in formula string displays abbreviated value 2
cell displays 0 when formula is valid 2

Top