Save you sanity!!

In an un-used cell enter 4
copy this cell
select the cells you want to modify

Edit PasteSpecial check the divide checkbox
--
Gary''s Student - gsnu200830


"klee" wrote:

I've run a sales report by item showing monthly sales for the last 3 years.

I need to divide each cell by 4.

I am sure there is a much easier way than what I'm currently doing... right
now I'm clicking in each cell, entering the "=" before the result, arrowing
to the end & pasting the "/4".

I think I'll go insane if I have to do this to all the cells...

Is there a way to select a range of cells & have it apply the same formula
to all of the cells at once?