software

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: www.excelforum.com/member.php...oamp;userid=32900
View this thread: www.excelforum.com/showthread...hreadid=527175Put -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:
gt;
gt; IS there a way to turn positive numbers to negative without going into
gt; the field at the top and keying in the minus (-) sign?
gt;
gt; Thanks,
gt;
gt; --
gt; rajivvyas
gt; ------------------------------------------------------------------------
gt; rajivvyas's Profile: www.excelforum.com/member.php...oamp;userid=32900
gt; View this thread: www.excelforum.com/showthread...hreadid=527175

--

Dave Peterson

Hi

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

Andy.

quot;rajivvyasquot; gt; wrote
in message ...
gt;
gt; IS there a way to turn positive numbers to negative without going into
gt; the field at the top and keying in the minus (-) sign?
gt;
gt; Thanks,
gt;
gt;
gt; --
gt; rajivvyas
gt; ------------------------------------------------------------------------
gt; rajivvyas's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32900
gt; View this thread: www.excelforum.com/showthread...hreadid=527175
gt;

Thanks a bunch.--
rajivvyas
------------------------------------------------------------------------
rajivvyas's Profile: www.excelforum.com/member.php...oamp;userid=32900
View this thread: www.excelforum.com/showthread...hreadid=527175