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.

 

[Guest]

Hi

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

Andy.

 

[rajivvyas]

Thanks a bunch.