How to make positive to negative in excel

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

1. First, you open the excel sheet and then write some positive values as shown in the picture below.
2. Then in column B, you have to write a negative one (-1) in all the cells.
3. 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.
4. Now you see that all your positive values have changed to negative values.

After learning this trick you will have no difficulty in making any value from positive to negative.