Sorry for wasting space but somehow (I have no idea how) the option for
calculation had changed from Automatic to Manual.

Is it possible that I imported a spreadshet with calculation set to manual
and this over-rode my automatic setting and it stayed that way?


"inquirer" wrote in message
...

I am doing something obviously stupid but can't see what
In a spreadsheet I have data in cols A and B
In cell B1 I have =(a1-0.375)
I have copied this to b2.b14 with the result shown:
1 0.625
2 0.625
3 0.625
4 0.625
5 0.625
6 0.625
7 0.625
8 0.625
9 0.625
10 0.625
11 0.625
12 0.625
13 0.625
14 0.625


If I go to cell b2 and then left click in the formula bar then hit enter,
b2
evaluates to 1.625. Same with b3, b4 etc.
What have I done to stop the formula evaluating correctly after I have
copied it?

Thanks Chris