One way. put -1 in an empty cell, select that cell, copy it, select the 50
cells you want to convert, do editpaste special and select multiply

--
Regards,

Peo Sjoblom

(No private emails please)


"chermaine" wrote in message
oups.com...
I would like to know is there a way to help putting a negative sign on
the selected cells.
Actually I have to transform the +numbers filled in the cells into a
negative numbers by simply putting a negative sign in front. Right now
i am so stupid by amend each cell whereas i have at least 50 cells to
change, so I wonder is there a way can speed up these kind of data
entry process??