|
column of negative numbers into positive numbers
Hello all-
If I have a column of negative numbers and I want them all to become positive numbers (-500 becomes 500, etc.), is there a quick way to do this? Also, if the column has a positive number in it, I would that to become negative... Thanks - Jason |
column of negative numbers into positive numbers
Put -1 in a spare cell, select and copy, select your column, edit/ paste
special/ multiply. Delete your -1 now you've finished with it. -- David Biddulph "ORLFREIGHTBOY" wrote in message ... Hello all- If I have a column of negative numbers and I want them all to become positive numbers (-500 becomes 500, etc.), is there a quick way to do this? Also, if the column has a positive number in it, I would that to become negative... Thanks - Jason |
column of negative numbers into positive numbers
=-A1
"ORLFREIGHTBOY" wrote: Hello all- If I have a column of negative numbers and I want them all to become positive numbers (-500 becomes 500, etc.), is there a quick way to do this? Also, if the column has a positive number in it, I would that to become negative... Thanks - Jason |
| All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com