G Guest Oct 24, 2005 #1 I need to change all positive numbers in the spreadsheet to negative numbers, and vice versa in Excel.
I need to change all positive numbers in the spreadsheet to negative numbers, and vice versa in Excel.
D Dave Peterson Oct 24, 2005 #3 Put -1 in an empty cell edit|copy that cell select your range to fix Edit|paste special|check multiply.
Put -1 in an empty cell edit|copy that cell select your range to fix Edit|paste special|check multiply.
G Guest Oct 24, 2005 #4 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.
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.
