CHANGE POSITIVES VALUES TO NEGATIVES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi andresg1975

Enter -1 in a empty cell
Copy this cell

Select your data
Edit>Paste Special
Choose Multiply
OK
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reallocate array cells value from positive to negative 0
Subtracting positive amts from negative and positive from positive 3
How to change numbers from positive to negative. 2
How to Show "+" for positive and "-" for negative 10
Excel VBA to match positive and negative transactions 3
summing only positive or negative values 2
HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN 5
Red cell for negative numbers in Excel 1

Back
Top