G Guest Dec 4, 2004 #1 how to reverse values of a series of numbers in a column from positive to negative by selecting them and then using a formula.thank you
how to reverse values of a series of numbers in a column from positive to negative by selecting them and then using a formula.thank you
F Frank Kabel Dec 4, 2004 #2 Hi one way (without a formula) - put -1 in an empty cell and copy this cell - select your numbers - goto 'Edit - Paste Special' and choose 'Multiply'
Hi one way (without a formula) - put -1 in an empty cell and copy this cell - select your numbers - goto 'Edit - Paste Special' and choose 'Multiply'
D Debra Dalgleish Dec 4, 2004 #3 If you need to show the formula on the worksheet, you can multiply each cell in the column by -1. For example: =A2 * -1
If you need to show the formula on the worksheet, you can multiply each cell in the column by -1. For example: =A2 * -1
