ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   1+1=0?? (https://www.excelbanter.com/excel-discussion-misc-queries/166749-1-1%3D0.html)

Nuno Guerra

1+1=0??
 
In my old excel files (same Excel version 2003), all the calculations returns
0.

Nuno Guerra

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.






All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com