excel formulas are showing as text

1If your formulas are displaying as formula text instead of the formula results
2try:
3
41.) Press these two keys together: Ctrl and ~   (2nd key is the TILDE).
5    This toggles all entries on a sheet between results and formula text and
6    vice versa.
7    
82.) Select the range where formulas are displaying as text and change the
9    Number Formatting from TEXT to GENERAL. Now re-enter the the formulas.
10
11
12