cell a7:=IF(B7=0,"",MONTH(C7)&DAY(C7))

when i select b7:h7 and 'insert, shift rows down' the fromula changes in a7 to =IF(B8=0,"",MONTH(C8)&DAY(C8))

How con I do this without a change to a7?