Delete the heading, drag your formula down from E1:E135

Overwrite the fomula in E2 with your heading.


Gord Dibben MS Excel MVP

On Mon, 28 Sep 2009 10:10:02 -0700, Kanmi
wrote:

oh thanks alot. There is no way i can drag it down. on E2 i have heading and
i don't want the formular to be showing when i click on E3:E135. PLEASE HELP

"cm" wrote:

If you copy the formula down column E as it is, the cell references will
change for M and N. If you do not want that, and all the values in Column E
should be the same, then E1 should read:
=365/($M$3/$N$3)


"Kanmi" wrote:

Hello, Please can anybody help me with this.

i want to put this formular on cell "E1" (=365/(M3/N3) and i want the
formular to apply to FROM "E3:E135". I want the formular to be on E1.

Please how can i go about this. God bless you as you take your time to ans
this. Thanks