View Single Post
  #1   Report Post  
Nih
 
Posts: n/a
Default Quick way to change negative #s to positive

Alot of times at work I need to take a column of numbers and change them to
either postive or negative numbers. I would like to be able to select the
cells I want then click a button to change the signs of all the cells I
selected. Is there such a button, like a +/- button?? If not is the fastest
way to do this I can find is to select the cells, hit ctrl H and replace the
- with blank.