Multiplying by -1 and then copy/pasting

M

MJames

I've come across a problem of late. If I have numbers A1:A10 (10, 20,
30,...100), and then in B1 I put "=-1*A1" this will equal -10, but then when
I try to copy that formula across B1:B10, I get -10 all the way
across.(instead of -10,-20,-30,...-100)

I'm working in a very long spreadsheet and simply need to change the sign of
all the values, but for some reason I can't get excel to do this.

I'm using Excel 2003
 
P

Peo Sjoblom

Change to automatic

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
G

Gord Dibben

Easier way to do this is.........

Enter -1 in an empty cell.

Copy that cell.

Select A1:A10 and Paste Special>Multiply>OK>Esc

A1:A10 will now be -10, -20 etc. with no formulas to change.

Delete the -1 cell.


Gord Dibben MS Excel MVP
 
Top