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

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

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

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

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

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

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

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


"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

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

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