change value in column to negative figures

[Peo Sjoblom]

1. Format an empty cell with the same format as the cells you want to
change,
2. type in -1 and press enter
3. Copy the cell
4. Select all cells you want to change and do edit>paste special and select
multiply