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. |
How do I convert numbers to the opposite sign?
times it by -1
|
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 |
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. |
All times are GMT +1. The time now is 06:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com