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

Put -1 in an empty cell
edit|copy that cell
select your range to fix
Edit|paste special|check multiply.



CindyatRWD wrote:

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


--

Dave Peterson