PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?UGF1bCBM?=
Guest
Posts: n/a
 
      16th May 2006
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
 
Reply With Quote
 
 
 
 
David Biddulph
Guest
Posts: n/a
 
      16th May 2006
"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


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:26 PM.