How to Remove Negative Sign with Flash Fill in Excel ?

Tutorial in brief

We am sure you have used flash fill once in your lifetime and if not, you must use it, it’s a game-changer. This is an insane method to turn negative numbers into positive, here are the steps.

1. First of all, in cell B2, enter the positive number for the negative number you have in cell A2.
2. After that, come to cell B3 and press shortcut key Ctrl + E.
3. At this point, in the B column, you have all the numbers in positive form.
4. Now, click on the small icon you have on the right side of column B and select “Accept Suggestions”.

Congratulations, you have converted all the negative numbers into positive with flash fill.

Note : This method is also not a dynamic one, but quick and easy to use.

Other Methods to convert Negative Number into Positive

Choose the tutorial that fits best for your case –

1. Multiply with Minus One to Convert a Positive Number in Excel
2. How to convert to an Absolute Number with ABS Function in Excel ?
3. Multiple Using Paste Special to convert Negative Figure into Positive In Excel
4. How to Remove Negative Sign with Flash Fill in Excel ?
5. How to apply Custom Formatting to Show as Positive Numbers in Excel ?
6. How to run a VBA Code to Convert to Positive Numbers in Excel ?
7. How to Use Power Query to Convert Get Positive Numbers ?