Excel is calculating automatically

[vijubansal]

I have received one file from somewhere, where putting only 3+2 is giving answer as 5 automatically as well as all "+", "-", "*", "/" are working and giving right answer, my question is, how it become possible??????


Looking forward to have answer.

 

[Colin Legg]

Tools | Options | Transition tab

Tick the Transition formula entry checkbox

 

[RoryA]

Check under Tools-Options on the Transition tab and see if 'Transition formula entry' has been checked. If so, uncheck it.

 

[vijubansal]

wow!!! gr8