Sub format_E5()
Range([e7], Cells(Rows.Count, "e").End(xlUp)).ClearFormats
Range([e7], Cells(Rows.Count, "e").End(xlUp)).NumberFormat = "dd mm yy hh:mm"
Range([e7], Cells(Rows.Count, "e").End(xlUp)).HorizontalAlignment = xlCenter
Range([e7], Cells(Rows.Count, "e").End(xlUp)).VerticalAlignment = xlCenter
Range([e7], Cells(Rows.Count, "e").End(xlUp)).WrapText = True
End Sub