Formula result disappeared

[nv77078]

Everytime I visit a cell with a formula in a certain column of my worksheet
and press enter, that cell will only show the formula instead of the result.
Any idea on how to show the result back again for those cells?
Nancy

 

[David Biddulph]

The cell is presumably formatted as text. Format as General (or Number) and
re-enter the formula.

 

[Ms-Exl-Learner]

Try this…

Press CNTRL + TILDE key, whch is available above the Tab Key.

Remember to Click Yes, if this post helps!

 

[David Biddulph]

That would work if it were all the formulae on the sheet which were being
displayed as formulae, but the wording of the OP suggested that the problem
was confined to one cell or one column, in which case it would sound more
likely to be due to the cell being formatted as text.

 

[nv77078]

This worked, thank you!

The cell is presumably formatted as text. Format as General (or Number) and
re-enter the formula.
--
David Biddulph




.

 

[Ms-Exl-Learner]

Yes David sir I missed to read the word "Certain Column", after reading your
reply I come to know that I have missed something to read or I read and
understood it wrongly.

Once Thanks for your Guidance!!!