View Single Post
  #4   Report Post  
bpeltzer
 
Posts: n/a
Default How do I convert numbers to the opposite sign?

Type a '-1' in some random cell and copy it (ctrl+C). Then select the cells
you want to switch and Edit Paste Special, select Values and Multiple and
click OK.


"CindyatRWD" wrote:

I need to change all positive numbers in the spreadsheet to negative numbers,
and vice versa in Excel.