In a cell alongside, add

=IF(A10,-A1,A1)

and copy down.

Then select column B, Copy, EditPastespecialValues.

Then delete column A.

--

HTH

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


"9541moosegirl" wrote in message
...
Please help!