Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range
Set r = Intersect(Target, [B11:B16])
If r Is Nothing Then Exit Sub
For Each r In r 'si entrées multiples
r.NumberFormat = """" & Application.Proper(Format(r, "dddd")) _
& """ dd """ & Application.Proper(Format(r, "mmmm")) & """ yyyy"
Next
End Sub