excel displays formula instead of value in one cell
 

As expected, some cells in my worksheet display the value of a formula in the
cell. Some will only display the formula. How do I change them to display
the value?

excel displays formula instead of value in one cell
 

Select the cell in question
Change the cell format to General
Press function key F2
Hit Enter

--
Biff
Microsoft Excel MVP


"auctionguy" wrote in message
...
As expected, some cells in my worksheet display the value of a formula in
the
cell. Some will only display the formula. How do I change them to
display
the value?

excel displays formula instead of value in one cell
 

Thanks! Much appreciated. Best Regards.

"auctionguy" wrote:

As expected, some cells in my worksheet display the value of a formula in the
cell. Some will only display the formula. How do I change them to display
the value?

excel displays formula instead of value in one cell
 

You're welcome!

--
Biff
Microsoft Excel MVP


"auctionguy" wrote in message
...
Thanks! Much appreciated. Best Regards.

"auctionguy" wrote:

As expected, some cells in my worksheet display the value of a formula in
the
cell. Some will only display the formula. How do I change them to
display
the value?