Hi

Using Excel 2007.

In row 1, i have a row of different numbers: 1, 4, 5, 6, ...

In row 2, I want all of it to be the negative of row 1. -1, -4, -5,..


So I used cell reference for the 1st cell and copy & paste the formula for
the whole row. But here a strange thing happened, all the cell in row 2 show
the value of my 1st cell, although in the function bar they show correctly
the formula and cell reference of their respective cells.

I used this method many times and this is the 1st time this happened. How do
I correct this problem?

Thanks