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 »

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: 3800
Joined: Wed Mar 11, 2020 5:31 pm

Re: Converting a column of negative numbers to positive ones

Post by SuperTech »

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.
goldermann@gmail.com
Posts: 2
Joined: Wed Jul 09, 2025 5:05 pm

Re: Converting a column of negative numbers to positive ones

Post by goldermann@gmail.com »

I found the fix that worked for me. I too imported from my card charge company. the fees were all negative and would not sum. The only way I found to convert them all to positive at the same time was using the search and replace command.
Under search,
type "-$",
click search all,
click replace tab,
type "$",
click replace all.
Capture.PNG
Post Reply

Return to “PlanMaker 2018 for Windows”