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
|