Is there an easy way to change a range of cells containing numbers from positive to negative?
K krisque Nov 11, 2004 #1 Is there an easy way to change a range of cells containing numbers from positive to negative?
F Frank Kabel Nov 11, 2004 #2 Hi - enter -1 in an empty cell - copy this cell - select your data - goto 'Edit - paste Special' and choose 'Multiply'
Hi - enter -1 in an empty cell - copy this cell - select your data - goto 'Edit - paste Special' and choose 'Multiply'
