"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

Quickly Convert Positive Values To Negative


If you have a range of cells where you need to convert each entry to a negative value, there is an easier and faster way than changing them individually. Excel's Paste Special option allows you to accomplish this task relatively easily.

  1. Type -1 in any empty cell.
  2. Click Edit, Copy.
  3. Select the cells containing the values you want to convert.
  4. Choose Edit, Paste Special.
  5. In the Paste section, select Values and in the Operation section, select Multiply.
  6. Click OK.
All the numbers have been changes from positive to negative, or vice versa. This is a great trick that can also be used to reduce numbers by a factor of 10, 100, etc. by using the Divide option.

Remember that this operation changes the underlying values of these cells not just the displayed value.


Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.