Mixed cell displays--values and formulas showing on same worksheet

[Compu Geek]

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

 

[מיכ×ל (מיקי) ×בידן]

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

 

[Compu Geek]

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.

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

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

 

[מיכ×ל (מיקי) ×בידן]

Select the "funny" range > 'DATA' > 'TEXT TO COLUMNS...' > 'FINISH'
Micky

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.

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

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