View Single Post
  #6   Report Post  
Shelly Gillett Poole Shelly Gillett Poole is offline
Junior Member
 
Posts: 1
Default

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 View Post
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