Converting positive values

  • Thread starter Thread starter New User
  • Start date Start date
N

New User

Just received a spreadsheet that has approx 9,000
quatities (ie: 1 , 55, 1000, etc).

How can I convert them over to negavtives (ie -1, -55, -
1000, etc)

Thanks for the help!
 
Enter -1 in an unused cell, say in X2.
Copy X2.
Select the range of the target numbers.
Activate Edit|Paste Special, choose Multiply.
 
This is the easiest way I have found

If you have the value 1000 in A1
= A1 * -1 in B1 in my Excel it gives the result -1000

Hope this helps.

All the best,

Steve Wilson.
 
Back
Top