How do I convert numbers to the opposite sign?

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

times it by -1

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

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.