Convert negative values to positive values - Formulas In Excel - Microsoft Excel Tutorials

11.  Convert negative values to positive

A worksheet contains negative values. To convert all of the negative values to positive values, perform the following steps.

To convert negative values to positive values:

1. Enter a series of negative values in cells B1:B10.
2. Select cell C1 and type -1.
3. Copy this cell.
4. Select cells B1:B10.
5. From the Edit menu, select Paste Special.
6. Select Multiply under Operation.
7. Click OK.

Note: After this, C1 can be cleared.



Watch the Video Tutorial - https://www.youtube.com/watch?v=Xah81en5WBM

  Hope You Like This Tutorial - Give Comments