How to make positive to negative in excel
In this Microsoft Excel blog post we will show you how to convert a positive value into a negative value. Also, with a simple Excel trick, we often need to change our values from positive to negative. If it is not possible to edit a single value, then you will make your problem easier. After this trick.
Positive and negative value trick
- First, you open the excel sheet and then write some positive values as shown in the picture below.
- Then in column B, you have to write a negative one (-1) in all the cells.
- Then copy all positive values of column A, then open the menu of paste Special in Column B and then click Multiply from the Option.
- Now you see that all your positive values have changed to negative values.
0 Comments