Turning positive numbers to negative

[rajivvyas]

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,

[Dave Peterson]

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

Hi

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

Andy.

"rajivvyas" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[rajivvyas]

Thanks a bunch.