In which case those cells are presumably formatted as text. Format as
General, then re-enter the formula.
--
David Biddulph

Compu Geek wrote:
This let's me toggle between displaying values and formulas for the
cells that were showing values. The cells that were showing formulas
continue to show formulas throughout.

"????? (????) ?????" wrote:

Try pressing ONCE the keys combination: CTRL + TILDE
[TILDE is the ~ key]
Micky


"Compu Geek" wrote:

I the same sheet of the same workbook, some of my cells are
displaying the value (for calculated values), whilst others are
displaying the formula. Originally, only the values were displaying.

I don't know what I did to get this...I think the green indicator
appeared on one of my cells, and when I clicked on it I chose one
of the options it displayed.

How do I get all my cells to appear consistently again?

This is Excel 2007