LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 187
Default CHANGE POSITIVES VALUES TO NEGATIVES

Hi

Cut your data from your actual column, select a cell in a helper column,
Paste it. Now copy your data from the helper column, select the cell in your
actual colum, Paste Special - "Subtract".

Jaleel



"andresg1975" wrote:

I NEED TO CHANGE POSITIVES VALUES TO NEGATIVE IN A LOT OF CELLS. HOW CAN I
ACCOMPLISH THIS WITHOUT DOINT IT ONE BY ONE. THANKS FOR YOUR HELP.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find the largest change of values in a column Ravager Excel Worksheet Functions 5 August 11th 06 07:00 PM
How do I change a range of values from + to -? Dave6 Excel Discussion (Misc queries) 2 May 15th 06 01:48 PM
Formulas not recalculating when values change on another sheet Bill Excel Worksheet Functions 0 September 15th 05 10:29 PM
Sort ignoring negatives and positives bangbanjo Excel Worksheet Functions 3 June 8th 05 12:21 AM
Change all values in an excel column at once? Sn0wman Excel Discussion (Misc queries) 4 April 25th 05 01:08 PM


All times are GMT +1. The time now is 05:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"