CHANGE POSITIVES VALUES TO NEGATIVES

A

andresg1975

I NEED TO CHANGE POSITIVES VALUES TO NEGATIVE IN A LOT OF CELLS. HOW CAN I
ACCOMPLISH THIS WITHOUT DOINT IT ONE BY ONE. THANKS FOR YOUR HELP.
 
R

Ron de Bruin

Hi andresg1975

Enter -1 in a empty cell
Copy this cell

Select your data
Edit>Paste Special
Choose Multiply
OK
 
D

Dave F

Multiply the cells by -1.

If the range of cells is A1:A1000, then in column B, starting in B1, put
=A1*-1, and fill down as appropriate.
 
J

Jaleel

Hi

Cut your data from your actual column, select a cell in a helper column,
Paste it. Now copy your data from the helper column, select the cell in your
actual colum, Paste Special - "Subtract".

Jaleel
 
Top