CONVERT NEGATIVE VALUES TO POSITIVE VALUES USING EXCEL

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

Microsoft Excel Tutorials,  Convert negative values to positive values using Microsoft Excel,  Microsoft Excel Video Tutorials,  Macros to perform tasks