#POSITIVE POSITIVE NEGATIVE SERIES#
This will create a series of positive numbers from any set of negative numbers or a mix of negative and positive numbers. You can also use the ABS() or absolute value function to return a number without its sign. Method 3 - ABS() Function to Convert Negative Value to Positive Values Remember to keep -1 the same since multiplying a positive number by a negative number will create a negative result. To convert any series of positive numbers to negative numbers, simply follow the exact same steps as in Method 1 above the only difference is that you will start with positive numbers in the original list this time. Method 2 - Convert Positive Values to Negative Values Now, you have a colum of positive values:.Select the option Multiply and then hit OK:.Right-click over the negative numbers and click Paste Special:.Copy the cell with the -1, just select the cell and hit Ctrl + C:.Add a cell with -1 in it near your negative numbers:.You can use the "paste special" method to change numbers from negative to positive or positive to negative. Method 1 - Convert Negative Values to Positive Values
I will show you a few ways to change negative numbers to positive numbers and back again in Excel.ĭon't forget to download the accompanying workbook so you can follow along with the tutorial.
0 kommentar(er)
