Changing negative amounts into positive.
Posted by Don W on November 08, 2001 3:14 PM
I am presently working on a budget, where sales are reflected with a minus sign. I know I can make this a positive number by inserting a row, and multiplying the cell by -1, or by going directly into each cell and removing the (-) sign. This will be very timely since there are alot of cells.
Is there a way to convert from negative to positive within the same cells with a formula or macro?
I'd appreciate your reply.
Posted by marbel on November 08, 2001 3:17 PM
Try putting a -1 into a blank cell, copying that cell and paste special / multiply to the values that need conversion.
mb
Posted by IML on November 08, 2001 3:18 PM
You could highlight your column and hit control F for the find function
Type in a hyphen, hit replace, and then replace all.
If you have exclusively negative numbers, you could put -1 in a cell and copy it. Highlight your column and paste special multiply over it.
Good luck.
