Private Sub Worksheet_Change(ByVal Cible As Range)
Dim Plg As Range, Cel As Range
Set Plg = Intersect(Columns(3), Cible)
If Not Plg Is Nothing Then
For Each Cel In Plg.Cells
Cel.Offset(, 1).NumberFormat = "General " & """" & Cel.Value & """"
Next
End If
End Sub