Thread
:
How do I change minus numbers to + numbers in a col in Excel?
View Single Post
#
2
Posted to microsoft.public.excel.charting
David Biddulph
Posts: n/a
How do I change minus numbers to + numbers in a col in Excel?
"Paul L" <Paul
wrote in message
...
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
Reply With Quote