Bonjour,
Voila un bout de code, il faut transformer le mois en ascii pauvre
Sub num_mois()
txt = Cells(1, 1)
txt = Trim(LCase(txt))
txt = Replace(txt, "é", "e")
txt = Replace(txt, "è", "e")
txt = Replace(txt, "û", "u")
Select Case txt
Case "janvier": num = 1
Case "fevrier": num = 2
Case "mars": num = 3
Case "avril": num = 4
Case "mai": num = 5
.......
End Select
End Sub