If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing groups of cells in Excel
In Excel 2003 can I change a group of cells (e.g. a column) so their results
all become negative or do I have to change each cell individually? |
#2
|
|||
|
|||
Changing groups of cells in Excel
If the values are all positive and you want to make them negative then
you can multiply by -1 (more on this later). However, if you have a mixture of positive and negative values in the column, you would need to apply a formula in a helper cell along the lines of: =-ABS(A1) To multiply all cells by -1, enter -1 in a blank cell somewhere. Then select that cell and click copy. Then highlight all the cells that you want to change and click on Edit | Paste Special | Values (check) | Multiply (check) | OK then Esc. Hope this helps. Pete On Aug 11, 12:53*pm, DBB9 wrote: In Excel 2003 can I change a group of cells (e.g. a column) so their results all become negative or do I have to change each cell individually? |
#3
|
|||
|
|||
Changing groups of cells in Excel
Hi
In a spare cell type -1 Copy the cell Select your range of data Paste SpecialMultiply -- Regards Roger Govier "DBB9" wrote in message ... In Excel 2003 can I change a group of cells (e.g. a column) so their results all become negative or do I have to change each cell individually? |
#4
|
|||
|
|||
Changing groups of cells in Excel
In an un-used cell enter -1
Copy this cell Select the cells you want to change and: Edit PasteSpecial check multiply. -- Gary''s Student - gsnu200799 |
Thread Tools | |
Display Modes | |
|
|