CHANGE A ROW OF POSTIVE NUMBERS TO NEGATIVE NUMBERS
I want to change a column of positve numbers to a column of negative numbers
|
CHANGE A ROW OF POSTIVE NUMBERS TO NEGATIVE NUMBERS
In any blank cell enter -1
Copy that cell Select your column of data to change Paste Special... Select "Multiply" OK Delete the -1 that you entered earlier. All of your cells in that column have now been multiplied by -1, thus converting positive to negative. The exact same process could be used to convert back to positive if needed. HTH, Elkar "Harlan" wrote: I want to change a column of positve numbers to a column of negative numbers |
CHANGE A ROW OF POSTIVE NUMBERS TO NEGATIVE NUMBERS
"Elkar" wrote: In any blank cell enter -1 Copy that cell Select your column of data to change Paste Special... Select "Multiply" OK Delete the -1 that you entered earlier. All of your cells in that column have now been multiplied by -1, thus converting positive to negative. The exact same process could be used to convert back to positive if needed. HTH, Elkar "Harlan" wrote: I want to change a column of positve numbers to a column of negative numbers |
CHANGE A ROW OF POSTIVE NUMBERS TO NEGATIVE NUMBERS
"Elkar" wrote: In any blank cell enter -1 Copy that cell Select your column of data to change Paste Special... Select "Multiply" OK Delete the -1 that you entered earlier. All of your cells in that column have now been multiplied by -1, thus converting positive to negative. The exact same process could be used to convert back to positive if needed. HTH, Elkar "Harlan" wrote: I want to change a column of positve numbers to a column of negative numbers I obviouly do not know how this works, but I want to be sure you receive my thanks for the prompt answer. I knew that multiplying by -1 was the way to go, but neve thought to put it in a blank space. Thanks for the help. Harlan |
All times are GMT +1. The time now is 11:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com