How can I convert positive numbers to negative in Excel??

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

Guest

Without adding a formula, does anyone know how to highlight a column of
numbers and reverse them from postive to negative without having to change
each cell individually?
 
Hi
- enter '-1 in an empty cell
- copy this cell
- select your data
- goto 'Edit - Pase Special' and choose 'Multiply'
 
In another cell, enter -1. Copy that value to the clipboard

Select the column

Goto Edit>PasteSpecial, and set the Multiply option in the Operation section
 
Back
Top