excel values from + to -
 

how to cahnge a selected series of values from positive to negative in one
swoop

thanks

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

Hi jjshariff

Enter -1
In a empty cell and copy this cell

Select your cells with numbers
Right click on them
Paste special
Multiply
OK


--
Regards Ron de Bruin
http://www.rondebruin.nl


"jjshariff" wrote in message ...
how to cahnge a selected series of values from positive to negative in one
swoop

thanks