#Negative plus positive code

I am sure you found all these methods helpful, but now, you have to tell me one thing.Дo you know any other method for this? Please share your views with me in the comment section. Even one method can be sufficient, but I have listed all these methods to help you to handle different situations. First of all, select any of the cells from the data range where you have negative numbers.ДЄs I said, to turn a negative number into a positive number you donвЂ™t need to use rocket science.Yes, you can use a power query to convert a negative number into a positive number and the best part is itвЂ™s a one-time setup. Use Power Query to Convert Get Positive Numbers Once you run this code, you canвЂ™t undo your action. First, it will check each cell of selection if there is a numeric value in it or not and then convert it to a positive value. To use this code, you just need to select the range of negative numbers and run this macro.

#Negative plus positive code

If you are a VBA lover then you can use a simple code to reverse the sign of negative numbers instantly. Run a VBA Code to Convert to Positive Numbers So, when you use it in the further calculation it will act as a negative number. If you select a cell and look at the formula bar, you can check, itвЂ™s still a negative number. Now, go to вЂњCustomвЂќ and in the type input bar, enter вЂњ#,#,#вЂќ.It will open the custom formatting options. After that, press the shortcut key Ctrl + 1.First of all, select the range of the cells you need to convert into positive numbers.And in this situation, you can use custom formatting. This is also a possibility that instead of converting a negative number you just want to show it as a positive number. 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

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.