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.