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 38 39 40 41 42 43
|
ValMontant = Replace(ValMontant, "-", "")
If ((Len(ValMontant)) = 0) Then
ValMontant = "000000000"
ElseIf ((Len(ValMontant)) = 1) Then
ValMontant = Replace(ValMontant, ".", "")
ValMontant = "000000" & ValMontant & "00"
ElseIf ((Len(ValMontant)) = 2) Then
ValMontant = Replace(ValMontant, ".", "")
ValMontant = "00000" & ValMontant & "00"
ElseIf ((Len(ValMontant)) = 3) Then
PositionSeparateur = InStr(ValMontant, ".")
ValMontant = Replace(ValMontant, ".", "")
If PositionSeparateur = 0 Then
ValMontant = "0000" & ValMontant & "00"
ElseIf PositionSeparateur = 2 Then
ValMontant = "000000" & ValMontant & "0"
End If
ElseIf ((Len(ValMontant)) = 4) Then
PositionSeparateur = InStr(ValMontant, ".")
ValMontant = Replace(ValMontant, ".", "")
If PositionSeparateur = 2 Then
ValMontant = "000000" & ValMontant
ElseIf PositionSeparateur = 3 Then
ValMontant = "00000" & ValMontant & "0"
End If
ElseIf ((Len(ValMontant)) = 5) Then
PositionSeparateur = InStr(ValMontant, ".")
ValMontant = Replace(ValMontant, ".", "")
If PositionSeparateur = 3 Then
ValMontant = "00000" & ValMontant
End If
End If |
Partager