Is there a way to highlight a column or a row and change all of the numbers
from negative to positive or vice versa without doing the change cell by
cell? Thanks
Is there a way to highlight a column or a row and change all of the numbers
from negative to positive or vice versa without doing the change cell by
cell? Thanks
"Paul L" <Paul [email protected]> wrote in message
news:[email protected]...
> Is there a way to highlight a column or a row and change all of the
> numbers
> from negative to positive or vice versa without doing the change cell by
> cell? Thanks
Put -1 in a spare cell, and Copy. Select the cells you want to change, then
Paste Special/ Multiply
--
David Biddulph
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks