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

A

Alma

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?
 
F

Frank Kabel

Hi
- enter '-1 in an empty cell
- copy this cell
- select your data
- goto 'Edit - Pase Special' and choose 'Multiply'
 
B

Bob Phillips

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
 
Top