Converting a column of negative numbers to positive ones

Post Reply
NemoUI
Posts: 1
Joined: Tue Apr 27, 2021 6:19 am

Converting a column of negative numbers to positive ones

Post by NemoUI » Tue Apr 27, 2021 6:24 am

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.

SuperTech
SoftMaker Team
SoftMaker Team
Posts: 1425
Joined: Wed Mar 11, 2020 5:31 pm

Re: Converting a column of negative numbers to positive ones

Post by SuperTech » Thu May 13, 2021 8:38 pm

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.

Post Reply

Return to “PlanMaker 2018 for Windows”