Pages

Showing posts with label Convert Negative Values To Positive. Show all posts
Showing posts with label Convert Negative Values To Positive. Show all posts

Saturday, October 30, 2010

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
Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews