Turning positive numbers to negative
 

IS there a way to turn positive numbers to negative without going into
the field at the top and keying in the minus (-) sign?

Thanks,


--
rajivvyas
------------------------------------------------------------------------
rajivvyas's Profile: http://www.excelforum.com/member.php...o&userid=32900
View this thread: http://www.excelforum.com/showthread...hreadid=527175

Turning positive numbers to negative
 

Put -1 in an empty cell
edit|copy
select your range of positive numbers
edit|paste special|check multiply
clean up that helper cell with -1 in it.




rajivvyas wrote:

IS there a way to turn positive numbers to negative without going into
the field at the top and keying in the minus (-) sign?

Thanks,

--
rajivvyas
------------------------------------------------------------------------
rajivvyas's Profile: http://www.excelforum.com/member.php...o&userid=32900
View this thread: http://www.excelforum.com/showthread...hreadid=527175

--

Dave Peterson

Turning positive numbers to negative
 

Hi

Type -1 into a cell, copy it, select your range and use Edit/Paste
Special/Multiply.
Job done!

Andy.

"rajivvyas" wrote
in message ...

IS there a way to turn positive numbers to negative without going into
the field at the top and keying in the minus (-) sign?

Thanks,


--
rajivvyas
------------------------------------------------------------------------
rajivvyas's Profile:
http://www.excelforum.com/member.php...o&userid=32900
View this thread: http://www.excelforum.com/showthread...hreadid=527175

Turning positive numbers to negative
 

Thanks a bunch.


--
rajivvyas
------------------------------------------------------------------------
rajivvyas's Profile: http://www.excelforum.com/member.php...o&userid=32900
View this thread: http://www.excelforum.com/showthread...hreadid=527175