jeste je nutno pouzit vlastnost EnableEvents - zabranit zacykleni, takze takto:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim isect As Object
'identifikace oblasti
Set isect = Application.Intersect(ActiveSheet.Range("d:d"), Target)
If isect Is Nothing Then Exit Sub
If Target.Resize(1, 1).Value = vbNullString Then Exit Sub ' delete
Application.EnableEvents = False
Target.Value = Format(Target.Value, "dd/mm/yyyy hh.mm")
Application.EnableEvents = True
End Sub