excel values from + to -

J

jjshariff

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

thanks
 
F

Frank Kabel

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

Ron de Bruin

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
 
Top