Converting a column of negative numbers to positive ones
Converting a column of negative numbers to positive ones
I'm new to PlanMaker and just learning how to use it. My immediate problem is converting a column of negatives numbers into positive ones. I looked through the manual but couldn't find out how to do it. If you know how to make the conversion, please let me know. Thanks for your assistance.
Re: Converting a column of negative numbers to positive ones
To convert all negative numbers of the column/range to positive, please follow these steps:
1. Add -1 to an empty cell and copy it to the clipboard.
2. Select the negative numbers of the destination column/range you want to convert.
3. Right click > Paste Special > Select "Multiply with destination" under operation which is on the bottom > click OK.
If all the values in the column are not negative you can use formula =ABS() also.
1. Add -1 to an empty cell and copy it to the clipboard.
2. Select the negative numbers of the destination column/range you want to convert.
3. Right click > Paste Special > Select "Multiply with destination" under operation which is on the bottom > click OK.
If all the values in the column are not negative you can use formula =ABS() also.