Formula result disappeared

  • Thread starter Thread starter nv77078
  • Start date Start date
N

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
 
The cell is presumably formatted as text. Format as General (or Number) and
re-enter the formula.
 
Try this…

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

Remember to Click Yes, if this post helps!
 
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.
 
This worked, thank you!

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




.
Click to expand...
 
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!!!
 
Back
Top