Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range, t$, dat$
Set r = Intersect(Target, [E5])
If Not r Is Nothing Then
t = Replace(r.Text, "/", "")
dat = Left(t, 2) & "/" & Mid(t, 3, 2) & "/" & Mid(t, 5, 2)
Application.EnableEvents = False
r.NumberFormat = "dd/mm/yy" 'format Date
r = "=--""" & dat & """"
t = r.Text
r.NumberFormat = "@" 'format Texte
r = IIf(t = dat, dat, "")
Application.EnableEvents = True
End If
End Sub