Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Convert Negative Number Into Positive Quickly In Excel

Date:2021-6-18 Author:Sandra

If you need to change all the negative number in Excel sheet into positive, what should you do? In today’s tutorial, we are going to learn two ways to convert negative numbers into positive.

Method 1 Insert Function

Select a blank cell and go to Formulas, chose Insert Function.

How To Convert Negative Number Into Positive Quickly In Excel

Choose ABS in the insert Function dialog box, and hit OK.

How To Convert Negative Number Into Positive Quickly In Excel

Click A3 cell and hit OK again.

How To Convert Negative Number Into Positive Quickly In Excel

Now the negative number -3585 in A3 had been converted into a positive number in C3.

How To Convert Negative Number Into Positive Quickly In Excel

You can pull down to fill the data to change all the negative numbers.

How To Convert Negative Number Into Positive Quickly In Excel

Method 2  Find and Replace

Highlight all the numbers and press Ctrl and F to open Find and Replace box.

Choose Replace and type “-” in Find what and press Blank key in Replace with. Then hit Replace All.

How To Convert Negative Number Into Positive Quickly In Excel

All the six negative numbers have been replaced with positive.

How To Convert Negative Number Into Positive Quickly In Excel

The second method will covert these negative numbers into positive in their original position. But the first way can’t. they are both practical.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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