Formulas, not results showing

[Jared2000]

Hi,

My Excel sheet only shows formulas, and not their results. For example, a cell shows =3*7 rather than 21.

Can anyone please provide me the porbably simple solution to my problem?

Thanks,
Jared

 

[Dan71]

Hi, the option is in Tools - Options. then at the bottom in window options is a tick box for Formulas.
Dan

 

[tony0682]

Goto Options -> View -> Uncheck Formulas in Windows Options

 

[Jared2000]

Neither of those seem to work

Hi,
Regardless of whether or not the box is ticked, the formula (and new formulas I enter) still show =3*7 rather than 21. Could something else be causing my problem?


Thanks,
Jared

 

[brian.wethington]

Is, or was the cell formatted as text before you inputed the formulas?

Also, shortcut for getting in and out of formula view:
Ctrl+accent (found above tab)

~Edit for clarification

 

[NBVC]

Try

Go to Edit|Replace

and Replace = with =

click Replace all.