How do you replace a range of cells from a positive value to a negative value.
B bpeltzer Nov 5, 2005 #2 Type -1 in some empty cell, and copy it. Select the range you want to change, and Edit > Paste Special. Select the radio button for 'multiply' and click OK.
Type -1 in some empty cell, and copy it. Select the range you want to change, and Edit > Paste Special. Select the radio button for 'multiply' and click OK.
