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 |
#11
|
|||
|
|||
change a positive number to negative
Oops...Sorry..Copy cell Right clickPasteSpecialMultiply OK....
-- If this post helps click Yes --------------- Jacob Skaria "MICHALK" wrote: "Jacob Skaria" wrote: Try the below --Enter -1 in a cell and copy the cell --Keeping the copy; select the data range to be converted (say A1:A100). --Press F5. From Goto windowSpecial select 'Multiply' and hit OK If this post helps click Yes --------------- Jacob Skaria "MICHALK" wrote: How to change a positive number to negative? Thanks...but I don't have Multiply as an option in that menu. |
#12
|
|||
|
|||
change a positive number to negative
I don't think your option 3 will turn a positive number to negative.
-- David Biddulph "NonTechie" wrote in message ... Try these. 1. When entering the number, put a minus sign in front of it. 2. If your positivie number is in cell A1, enter =-a1 in, say cell b1. 3. If you have a group of mixed numbers (positive and negative), use an IF statement in cell b1. E.g. =if(a1=0,a1,-a1) and copy. "MICHALK" wrote: How to change a positive number to negative? |
#13
|
|||
|
|||
change a positive number to negative
Pleaes note that this option will only work if you have only +ve numbers in
your selection....or else you will have to use a helper column with a formula.. "Jacob Skaria" wrote: Oops...Sorry..Copy cell Right clickPasteSpecialMultiply OK.... -- If this post helps click Yes --------------- Jacob Skaria "MICHALK" wrote: "Jacob Skaria" wrote: Try the below --Enter -1 in a cell and copy the cell --Keeping the copy; select the data range to be converted (say A1:A100). --Press F5. From Goto windowSpecial select 'Multiply' and hit OK If this post helps click Yes --------------- Jacob Skaria "MICHALK" wrote: How to change a positive number to negative? Thanks...but I don't have Multiply as an option in that menu. |
#14
|
|||
|
|||
change a positive number to negative
"Jacob Skaria" wrote: Pleaes note that this option will only work if you have only +ve numbers in your selection....or else you will have to use a helper column with a formula.. "Jacob Skaria" wrote: Oops...Sorry..Copy cell Right clickPasteSpecialMultiply OK.... -- If this post helps click Yes --------------- Jacob Skaria "MICHALK" wrote: "Jacob Skaria" wrote: Try the below --Enter -1 in a cell and copy the cell --Keeping the copy; select the data range to be converted (say A1:A100). --Press F5. From Goto windowSpecial select 'Multiply' and hit OK If this post helps click Yes --------------- Jacob Skaria "MICHALK" wrote: How to change a positive number to negative? Thanks...but I don't have Multiply as an option in that menu. Paste special.... OK......but that doesn't change the positive # that's already there. |
#15
|
|||
|
|||
change a positive number to negative
Michal, Are you sure you entered -1 to a cell and copied the cell and
***selected *** the +ve numbers to be converted and did the paste special...It works even if the number cells are formatted to text.. "MICHALK" wrote: "Jacob Skaria" wrote: Pleaes note that this option will only work if you have only +ve numbers in your selection....or else you will have to use a helper column with a formula.. "Jacob Skaria" wrote: Oops...Sorry..Copy cell Right clickPasteSpecialMultiply OK.... -- If this post helps click Yes --------------- Jacob Skaria "MICHALK" wrote: "Jacob Skaria" wrote: Try the below --Enter -1 in a cell and copy the cell --Keeping the copy; select the data range to be converted (say A1:A100). --Press F5. From Goto windowSpecial select 'Multiply' and hit OK If this post helps click Yes --------------- Jacob Skaria "MICHALK" wrote: How to change a positive number to negative? Thanks...but I don't have Multiply as an option in that menu. Paste special.... OK......but that doesn't change the positive # that's already there. |
#16
|
|||
|
|||
change a positive number to negative
"Pete_UK" wrote: Try this: =MIN(A1,-A1) This will keep negative numbers and turn positive numbers to negative. Hope this helps. Pete On Nov 12, 5:07 pm, MICHALK wrote: How to change a positive number to negative? . Thanks, but was wanting something faster....want values only. |
#17
|
|||
|
|||
change a positive number to negative
"Jacob Skaria" wrote: Michal, Are you sure you entered -1 to a cell and copied the cell and ***selected *** the +ve numbers to be converted and did the paste special...It works even if the number cells are formatted to text.. "MICHALK" wrote: "Jacob Skaria" wrote: Pleaes note that this option will only work if you have only +ve numbers in your selection....or else you will have to use a helper column with a formula.. "Jacob Skaria" wrote: Oops...Sorry..Copy cell Right clickPasteSpecialMultiply OK.... -- If this post helps click Yes --------------- Jacob Skaria "MICHALK" wrote: "Jacob Skaria" wrote: Try the below --Enter -1 in a cell and copy the cell --Keeping the copy; select the data range to be converted (say A1:A100). --Press F5. From Goto windowSpecial select 'Multiply' and hit OK If this post helps click Yes --------------- Jacob Skaria "MICHALK" wrote: How to change a positive number to negative? Thanks...but I don't have Multiply as an option in that menu. Paste special.... OK......but that doesn't change the positive # that's already there. Jacob, Thank you soooo much. Followed your advice and hit escape and it worked!!! |
|
Thread Tools | |
Display Modes | |
|
|