A fairly quick fix is to highlight the column of negative numbers; go to the Home tab and click on Find & Select drop down. Click on Replace. On the Replace tab, Find what: box put in a negative sign and in the Replace with: box hit the space bar once. Then you can replace one at a time or replace all the negatives in the column by clicking on Replace All.
Quote:
Originally Posted by Chips
Excel 2007
I have a column of numbers, all negative.
Like:
-213.00
-4,521.78
I want to change them to positive.
Not sure how to do this.
Thanks,
GC
|