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.
-
goldermann@gmail.com
- Posts: 2
- Joined: Wed Jul 09, 2025 5:05 pm
Re: Converting a column of negative numbers to positive ones
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.
Under search,
type "-$",
click search all,
click replace tab,
type "$",
click replace all.
