How do I change minus numbers to + numbers in a col in Excel?

's Computer Specifications

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

's Computer Specifications

"Paul L" <Paul (E-Mail Removed)> wrote in message
news:74D3CE9E-0454-4AA5-89B8-(E-Mail Removed)...
> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel, change column of negative numbers to positive numbers?	Nita	Microsoft Excel New Users	3	27th Nov 2007 04:54 AM
Subtotaling minus negative numbers and posative numbers	lehigh46	Microsoft Excel Worksheet Functions	3	18th Jul 2007 01:29 PM
how can I globally change minus numbers to positive ones?	=?Utf-8?B?amFtZXM=?=	Microsoft Excel Misc	1	9th Mar 2007 01:05 AM
Change minus numbers to zero in cell	Bob	Microsoft Excel Discussion	3	24th Oct 2006 02:48 AM
sort a column of numbers including minus numbers	Rasoul Khoshravan Azar	Microsoft Excel Discussion	7	30th Mar 2004 09:17 AM