View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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
...