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?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=474178