Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

Learn 2 ways to reverse the sign of a number from positive to negative or negative to positive in Excel.

https://www.excelcampus.com/tips/reverse-number-sign/

Flipping or reversing the number signs to positive or negative is a common task in Excel. In this video we look at two quick ways to accomplish this.

First, we can use a formula to multiply an existing cell by negative one *-1.

Second, we can use the Paste Special Multiply Operation to copy a cell that contains a -1 and multiply an existing range of cells to reverse the signs.
00:00 Introduction
01:33 Multiply
02:13 Copy Paste Special
02:55 Go to Special
04:19 Paste Special for Formulas