no formula calculation

J

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??
 
D

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?
 
A

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.
 
Top