Function Price(Str)
If Instr(Str,".") Then
If Len(Right(Test,Len(Test)-InstrRev(Test,"."))) = 0 Then
Str = Str &"00"
ElseIf Len(Right(Test,Len(Test)-InstrRev(Test,"."))) = 1 Then
Str = Str &"0"
End If
Else
Str = Str &"00"
End If
Price = Replace(Str, ".", "")
End Function
Function Price(Str)
If Instr(Str,",") Then
Com = Len(Right(Str,Len(Str)-InstrRev(Str,",")))
ElseIf Instr(Str,".") Then
Com = Len(Right(Str,Len(Str)-InstrRev(Str,".")))
End If
If Com = 0 Then
Str = Str &"00"
ElseIf Com = 1 Then
Str = Str &"0"
ElseIf Com > 2 Then
NewCom = Com-2
Str = Left(Str, Len(Str)-NewCom)
End If
Str = Replace(Str, ",", "")
Price = Replace(Str, ".", "")
End Function