Forumlas Not Executing

T

Trey

Hello,

I'm experiencing something odd -- whenever I type in a formula into a
particular spreadsheet, it doesn't execute. The formula prints in the cell as
if it were text. I haven't had this problem with other spreadsheets. Did I
somehow turn a global setting off where the spreadsheet doesn't execute
formulas?

Thanks for your help!
 
G

Gary''s Student

If the formula in the cell appears like the formula in the formula bar then
there are two possible explanations:

1. you are in equation view. Touch CNTRL-~ to correct this.

2. the cells were formatted as text before the formulae were entered. To
correct this, re-format the cell as General and then click at the end of the
formula bar and touch enter
 
T

Trey

Gary''s Student said:
If the formula in the cell appears like the formula in the formula bar then
there are two possible explanations:

1. you are in equation view. Touch CNTRL-~ to correct this.

2. the cells were formatted as text before the formulae were entered. To
correct this, re-format the cell as General and then click at the end of the
formula bar and touch enter
Click to expand...

Thank you for your help! I got things up and running. :)
 
Top