2 Ways to Reverse the Number Sign Positive Negative in Excel
605.3 هزار بار بازدید -
8 سال پیش
-
Sign up for our Excel
Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
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/reve...
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
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/reve...
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
8 سال پیش
در تاریخ 1395/12/12 منتشر شده
است.
605,323
بـار بازدید شده