Excel 2007 : Cant copy formula down column

This is really frustrating, in 2003 I would write a formula, i.e. =-A2 and then drag id down the column and the forumla would adjust to its relative placement, so that in the next row of that column the formula would be =-A3 ect..

I am now working with Excel 2007, and when I preform this the formula does reflect the change BUT the value stays the same throuh out the entire column. this is 100% incorrect.

I have read the help

I have entered the formula in various different ways

I have pressed CTR + Enter and then dragged,

this is a simple function, why can I not preform it!!!


Please help


Thanks