1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| Sub Anita()
Dim counter As Integer
Dim Position As Integer
Dim j As Integer
Dim W As Integer
For counter = 1 To Feuil1.Cells(65536, 1).End(xlUp).Row
If Cells(counter, 1).Value Like "*,*" Then
For j = 1 To Len(Cells(counter, 1).Value)
If Mid(Cells(counter, 1).Value, j, 1) = "," Then
Position = j
End If
Next j
If Len(Cells(counter, 1).Value) - Position = 1 Then
Cells(counter, 2).Value = Cells(counter, 1).Value & "00"
ElseIf Len(Cells(counter, 1).Value) - Position = 2 Then
Cells(counter, 2).Value = Cells(counter, 1).Value & "0"
Else
W = InStr(1, StrReverse(Cells(counter, 1).Value), ",") + 1
If InStr(W, StrReverse(Cells(counter, 1).Value), ",") = 0 Then
Cells(counter, 2).Value = CInt(Format(Cells(counter, 1).Value * 1000, "#,##0"))
Else
Cells(counter, 2).Value = Cells(counter, 1).Value
End If
End If
Else
Cells(counter, 2).Value = Cells(counter, 1).Value
End If
Next counter
End Sub |
Partager