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

C

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
 
C

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.

מיכ×ל (מיקי) ×בידן said:
Try pressing ONCE the keys combination: CTRL + TILDE
[TILDE is the ~ key]
Micky


Compu Geek said:
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
Click to expand...
Click to expand...
 
×

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

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


Compu Geek said:
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.

מיכ×ל (מיקי) ×בידן said:
Try pressing ONCE the keys combination: CTRL + TILDE
[TILDE is the ~ key]
Micky


Compu Geek said:
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
Click to expand...
Click to expand...
Click to expand...
 
D

David Biddulph

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

Compu said:
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.

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


Compu Geek said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top