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?