Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change all cells from minus to plus and plus to minus
Hi all, I have Excel 2007
How can I change from -to plus in a worksheet The cells have now negative and I want all to be positive, how to do it? eks : A1 A2 A3 A4 -214 683 -384 454 want to change to A1 A2 A3 A4 214 -683 384 -454 -- Just a regular user :) |
#2
|
|||
|
|||
Answer: How to change all cells from minus to plus and plus to minus
How to Change Signs of Cells in Excel
To change the signs of cells in Excel, follow these steps:
This will multiply all the values in the selected range by -1, effectively changing all the minus signs to plus signs and vice versa.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change all cells from minus to plus and plus to minus
Hi,
Put -1 in a cell and copy it. Select your numbers then Edit|Paste special Select Multiply Click OK Delete the cell with -1 in Mike "Rockbear" wrote: Hi all, I have Excel 2007 How can I change from -to plus in a worksheet The cells have now negative and I want all to be positive, how to do it? eks : A1 A2 A3 A4 -214 683 -384 454 want to change to A1 A2 A3 A4 214 -683 384 -454 -- Just a regular user :) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change all cells from minus to plus and plus to minus
I just noticed Excel 2007. The menu structure may be different but the method
will be the same "Mike H" wrote: Hi, Put -1 in a cell and copy it. Select your numbers then Edit|Paste special Select Multiply Click OK Delete the cell with -1 in Mike "Rockbear" wrote: Hi all, I have Excel 2007 How can I change from -to plus in a worksheet The cells have now negative and I want all to be positive, how to do it? eks : A1 A2 A3 A4 -214 683 -384 454 want to change to A1 A2 A3 A4 214 -683 384 -454 -- Just a regular user :) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change all cells from minus to plus and plus to minus
Sorry about the multiplicity, but did not see that that other choice was a
better place to ask, sorry Mike. Anyway a million thanks for the reply :) was so nice to finally make it work -- Just a regular user Mike H skrev: Hi, Put -1 in a cell and copy it. Select your numbers then Edit|Paste special Select Multiply Click OK Delete the cell with -1 in Mike "Rockbear" wrote: Hi all, I have Excel 2007 How can I change from -to plus in a worksheet The cells have now negative and I want all to be positive, how to do it? eks : A1 A2 A3 A4 -214 683 -384 454 want to change to A1 A2 A3 A4 214 -683 384 -454 -- Just a regular user :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change color of text when figure becomes minus | Excel Discussion (Misc queries) | |||
how can I globally change minus numbers to positive ones? | Excel Discussion (Misc queries) | |||
CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS | Excel Discussion (Misc queries) | |||
plus and minus sign in cells | Excel Worksheet Functions | |||
change the colour of text in cell for minus figure | Excel Worksheet Functions |