change value in column to negative figures
 

change value in column to negative figures
 

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 editpaste special and select
multiply


--
Regards,

Peo Sjoblom




"nads" wrote in message
...