how to cahnge a selected series of values from positive to negative in one swoop thanks
J jjshariff Dec 2, 2004 #1 how to cahnge a selected series of values from positive to negative in one swoop thanks
F Frank Kabel Dec 2, 2004 #2 Hi - enter -1 in an empty cell - copy this cell - select your numbers - goto 'Edit - Paste Special' and select 'Multiply'
Hi - enter -1 in an empty cell - copy this cell - select your numbers - goto 'Edit - Paste Special' and select 'Multiply'
R Ron de Bruin Dec 2, 2004 #3 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
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