View Formulas Not Toggling

[HighAndWilder]

Hi

I have a sheet that shows the formula in cells by default when I enter a new formula into a cell.

Uisng the 'Show Formulas' option on the Formulas tab does not toggle between the formula and the value.

Also using the shortcut Ctrl` does not work.

If I create a new worksheet or workbook everything works perfectly.

Anybody any ideas?

Thanks

 

[Peter_SSs]

Have a look at the cell formatting of the problem sheet/cell(s). It/they are possibly formatted as Text? If so try changing to General or Number or whatever is appropriate for you then re-enter the formula(s).

 

[joeu2004]

try changing to General or Number or whatever is appropriate for you then re-enter the formula(s).

You can use Find/Replace to "re-enter" the formulas. Select the cells, press ctrl+H, enter "=" (without quotes) into the Find and Replace fields, then click Replace All.

 

[HighAndWilder]

Have a look at the cell formatting of the problem sheet/cell(s). It/they are possibly formatted as Text? If so try changing to General or Number or whatever is appropriate for you then re-enter the formula(s).

Thanks Peter

That works fine.

Onwards and upwards now.

 

[Peter_SSs]

Thanks Peter

That works fine.

Onwards and upwards now.

You are welcome. Glad to help.