Hi there,

I have inherited a worksheet, that seems to be doing something rather odd...

Lets say there is data in column A, I now enter a simple subtraction formula
in cell A1 and the result is 12. If I copy this formula down a few rows, 12
apears as the result in all cells (which is not the correct answer, but
rather a value that has been copied).

What is more intesting is if I then click into cell A2 and press 'Enter' the
forumla is shown as expected. Then when I navigate awat from cell A2 the
correct answer appears!

I have tried various formatting, and checks but I can seem to resolve this.

Any ideads please.....