Put -1 in a cell
Copy that cell
Select all the positives
EditPastespecial, and select multiply
OK
Clear the -1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"michelle" wrote in message
...
I often have a list of possitive numbers that I need to change to negative
is
there a funtion to do this or do I have to do it all manually