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

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

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

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

"Sammy" wrote:

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

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

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
"Sammy" wrote in message ...
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

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

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.
--
David Biddulph

"Sammy" wrote in message
...
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

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

You are a STAR thank you sooooooooooo Much!!!

"Mike H" wrote:

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

"Sammy" wrote:

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