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