View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sheila D Sheila D is offline
external usenet poster
 
Posts: 65
Default Why do all my calculations/formulas equal zero?

Is it set for Manual calculation? Check the Tools, Options, Calculation tab

Sheila
www.c-i-m-s.com
MS Office training - London

"Andy" wrote:

I've recently been upgraded to excel 2003 and when I open a file I'd been
working on in excel 97 any formula entered has the result '0'. Even if I go
to a blank cell and type '=1+1' the answer is still 0.

Any ideas anyone?