excel

J

jjshariff

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

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

If you need to show the formula on the worksheet, you can multiply each
cell in the column by -1. For example: =A2 * -1
 
Top