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