![]() ![]() Whereas Method 1 may cause you to end up with mixed results if you had some negative and some positive values in the starting list, this method will only allow for positive numbers to be created, no matter what. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |