Hi
- enter -1 in an empty cell
- copy this cell
- select your numbers
- goto 'Edit - Paste Special' and select 'Multiply'

--
Regards
Frank Kabel
Frankfurt, Germany

"jjshariff" schrieb im
Newsbeitrag ...
how to cahnge a selected series of values from positive to negative
in one
swoop

thanks