Thread: 1+1=0??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nuno Guerra Nuno Guerra is offline
external usenet poster
 
Posts: 3
Default 1+1=0??

It was checked to automatic, moreover I tried to change to manual then to
automatic again. Saved and closed. When I open all formulas started to work.
Has no sense, but it worked.
Thank you.

"David Biddulph" wrote:

Have you checked that Tools/ Options/ Calculation is set to automatic, not
manual?
--
David Biddulph

"Nuno Guerra" wrote in message
...
In my old excel files (same Excel version 2003), all the calculations
returns
0.
If I try in a new cell this formula: =1+1 it returns 0.
All my formula calculations, SUM's, AVERAGE's had stoped running.

But if I open a new excel file all works fine.

Any help?
Thank you.