In Excel, how can a range of Pos #'s be changed to negative num

S

Stuart Millner

I dulicate a large series of cells that are all positive. Is there a
shortcut to change them to all negaive?
 
G

Govind

Hi,

Type -1 in a cell, copy that and then select the range, which has the
positive numbers which you want to convert to negative.

Right click on the range, select paste special, and choose action as
'Muliply'.

Regards

Govind.
 
Top