Sub transChiffre()
Dim chiffre As Double
Dim lenChiffre As Integer
Dim droiteChiffre As String
Dim cel As Range
Dim Pdecimale As String
For Each cel In Selection
chiffre = Str(cel.Value)
lenChiffre = Len(chiffre)
droiteChiffre = Right(chiffre, 1)
pos = InStr(1, chiffre, '.')
Pdecimale = Mid(chiffre, pos + 1)
nbzero = Len(Pdecimale) - 1
zero = Application.WorksheetFunction.Rept('0', nbzero)
cel.Offset(0, 1).Value = '0.' & zero & droiteChiffre
Next cel
End Sub