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
...
|