You can:
- put '-1' in an empty cell and copy this cell
- select your data
- goto 'Edit - Paste Special' and choose 'Multiply'

or

create a helper column and use this formula:

=-A1 (aussmuing your numnber is in A1) and drag down the formula.


"mustard" wrote:


I would like to know if there is any way to have a formula/function that
takes a value from another cell (I know how to do that part) and then
makes the number negative if the original is positive - or else makes
the number positive if the original is negative. Any ideas?


--
mustard
------------------------------------------------------------------------
mustard's Profile: http://www.excelforum.com/member.php...o&userid=20017
View this thread: http://www.excelforum.com/showthread...hreadid=470855