How To Convert Negative Values To Positive In Excel

The Steps below shows how to convert a negative number to a positive number.

Write -1 in a blank cell, copy it and then select the negative numbers.

Note: If a negative number are not adjacent, select the first negative number and then hold Ctrl key, and select the other negative numbers.

minus one

After you have selected all the negative number, right click, a drop down menu will appear from which you have to select “Paste Special”.

paste special

A new drop down menu will appear. Select “Paste Special” option at the bottom of the drop down menu then select “Multiply” option from the operation. Click ok.


All the negative number selected are now positive.

numbers converted


You can download the Template here – Download
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell