no formula calculation

[Junior Trimon]

In the worksheet no formulas are calculated anymore.

When I put the following in a cell:

=A1+B1

This text is displayed, no calculation is made. Even when
I put the following in, =1+3 no calculation is made.
Everything is displayed as is.

What is the problem??

 

[Dave Peterson]

Is the cell formatted as General (or some number)? If it's formatted as Text,
change it to General, then select the cell and hit F2. Then Enter.

You don't have a space character before the leading equal sign?

And you don't have tools|options|view tab|formulas checked, do you?

 

[Andy B]

Junior

Try Ctrl and ` (which is just to the left of your number 1). This switches
between formulas and results. You can also get this from
Tools/Options/View/Formulas

Andy.

 

[jtri]

Thanx,

Good tip, the shortcut. There is always something new to
learn