Sub formatJJ()
Dim i As Long
With Sheets("feuil1")
For i = 2 To .Cells.Find("*", , , , xlByRows, xlPrevious).Row
.Cells(i, 1) = Application.Proper(.Cells(i, 1))
.Cells(i, 2) = UCase(.Cells(i, 2))
.Cells(i, 6).NumberFormat = "0#"" ""##"" ""##"" ""##"" ""##"
Next
With .Cells.Font
.Name = "Arial Unicode MS"
.Size = 10
End With
End With
End Sub