![conditional formating with spreadsheet converter conditional formating with spreadsheet converter](https://exceltable.com/en/formatting/images/formatting8-1.png)
This is also a possibility that instead of converting a negative number you just want to show it as a positive number.
![conditional formating with spreadsheet converter conditional formating with spreadsheet converter](https://i.ytimg.com/vi/twGRXc9n6rY/maxresdefault.jpg)
Apply Custom Formatting to Show as Positive Numbers Note: This method is also not a dynamic one, but quick and easy to use. Now, click on the small icon you have on the right side of column B and select “Accept Suggestions”.Ĭongratulations, you have converted all the negative numbers into positive with flash fill.At this point, in the B column, you have all the numbers in positive form.After that, come to cell B3 and press shortcut key Ctrl + E.First of all, in cell B2, enter the positive number for the negative number you have in cell A2.So to convert them into positive you just need to enter the formula in cell B2 and drag it up to the last cell. So you can use the same method in excel to convert a negative number into a positive.Īll you have to do just multiply a negative value with -1 and it will return the positive number instead of the negative.īelow you have a range of cells with negative numbers. Unlike me, if you are good at maths, I am sure you know that when you multiply two minus signs with each other, the result is always positive. Multiply with Minus One to Convert a Positive Number
![conditional formating with spreadsheet converter conditional formating with spreadsheet converter](https://nebula.addteq.com/blog/files/178980273/178980274/1/1571063858000/Capture+2019-10-10+at+16.53.28.png)
So today in this post, I’d like to share all those methods with you. So this time I grabbed a paper and listed all the methods which I can use to convert a negative number into a positive. But have you ever checked how my different methods you have to do this? Well, I am always curious to know about different methods to do a task in Excel. I am sure, this often happens with you, when you get some negative numeric values, and after that, you convert them into positive. You know, the thing for which he asked is a common kind of task. Hey Puneet, how many methods we have to convert a negative number into a positive one? Last week, I got an email from one of my subscribers with a question. And you will be amazed that I have got 7 different ways which you can use to deal with negative numbers.