How do I prefix a worksheet of numbers with a Minus (-) Sign

[Guest]

I have a whole worksheet full of positive numbers and would like to reverse
them to negative numbers without having to retype them in. Would anyone know
a shortcut whereby i would be able to prefix all the numbers with minus sign?

Many thanks

 

[Guest]

Hi,

Type -1 in a cell somewhere, select the cell and copy it.
Select your positive numbers and then

Edit|Paste Special|Multiply and click OK.

Delete the cell with -1 in

Mike

 

[Robert McCurdy]

Can you select them, copy, select an empty area or new worksheet, and from PasteSpecial pick subtract?
Clear original range, then Copy/move copied values back to the original range location.


Regards
Robert McCurdy
I have a whole worksheet full of positive numbers and would like to reverse
them to negative numbers without having to retype them in. Would anyone know
a shortcut whereby i would be able to prefix all the numbers with minus sign?

Many thanks

 

[David Biddulph]

Put -1 in a spare cell (on that sheet or another one), select and copy it,
then select your range of positive numbers, Edit, Paste Special/ Multiply.

 

[Guest]

You are a STAR thank you sooooooooooo Much!!!

Hi,

Type -1 in a cell somewhere, select the cell and copy it.
Select your positive numbers and then

Edit|Paste Special|Multiply and click OK.

Delete the cell with -1 in

Mike