Private Sub CommandButton1_Click()
Dim DLig As Long
With Sheets("En cours")
DLig = .Range("D8").End(xlDown).Row
.Columns("A:A").NumberFormat = "dd/mm/yyyy"
.Columns("B:D").NumberFormat = "@"
.Columns("E:E").NumberFormat = "General"
.Columns("F:J").NumberFormat = "@"
.Range("a8:j" & DLig).Sort key1:=.Range("a8"), order1:=xlAscending, Header:=xlYes
.Columns("E:E").NumberFormat = "# ##0.00 €"
End With
End Sub