How to quickly convert positive number into negative number

There are billion of users who are working on the MS Excel on daily basis. Sometime you need to quickly change all positive number to negative numbers. In this guide we will discuss how to quickly convert positive number into negative number.

All we know Microsoft Excel is an important spreadsheet software. It is used for numeric calculations, representing data into different charts, data analysis, modelling and many more. You can easily solve complex calculation with the help off different functions in MS Excel.

How to quickly convert positive number into negative number

When you are working with MS Excel, sometime you need to quickly convert positive number into negative number. If you want to convert all positive number with negative number it’ll take lot of time. But after reading few given simple steps you can quickly convert positive number into negative number.

Must Read: VLookup to find first few characters in Excel

How to quickly convert positive number into negative number

Step 1: Open an existing worksheet in which you want to quickly convert positive number into negative number.

Step 2: Type -1 in any blank cell. Now, select the cell and copy the negative cell value.

Step 3: Select the range of cell in which you want to quickly convert positive number into negative number.

Step 4: Click on the Home tab > Click on the drop down arrow of Paste button > Click on the “Paste Special” box. You can also press Ctrl+ Alt+ V to directly open the “Paste Special” dialogue box.

Must Read: Prevent duplicate values with Data Validation in MS Excel

Step 5: Select “All” in the Paste category and choose “Multiply” option in the operation category in the paste special box. Finally click on he OK button. After finish all these steps you can see all the positive numbers with in selected range of cells are quickly convert into negative numbers.

After reading this trick you can quickly convert positive number into negative number. If you have any query regarding this article please write us in the comment box. Thanks to all.

Leave a Reply

Your email address will not be published. Required fields are marked *