View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Colin Macleod Colin Macleod is offline
external usenet poster
 
Posts: 8
Default Dividing by fixed number

I want to replace a number of cells on a worksheet with new values. These
new values will be the existing value divided by 0.8775. I realise I can do
this by using EditPaste SpecialDivide - but I want to be able to see the
division in the Formula Bar rather than just the end value. At the moment,
I'm just going through on a cell-by-cell basis, and editing each one by
hand. Is there a quicker way to do this?

Thanks