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.
--
David Biddulph

"nv77078" wrote in message
...
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

This worked, thank you!

"David Biddulph" wrote:

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

"nv77078" wrote in message
...
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


.

Try this€¦

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

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"nv77078" wrote:

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

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.
--
David Biddulph

"Ms-Exl-Learner" wrote in message
...
Try this.

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

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"nv77078" wrote:

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

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!!!

--------------------
(Ms-Exl-Learner)
--------------------


"David Biddulph" wrote:

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.
--
David Biddulph

"Ms-Exl-Learner" wrote in message
...
Try this.

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

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"nv77078" wrote:

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


.