Lyuciena
0
0
, 20 2007 . 22:55 ()
Function (SourceDigits As Currency) As String
Dim STRNG As String, CHAR, Result As String, Prom As String
Dim I, STRNG_len As Long
Dim SourceDigTail As Currency
SourceDigTail = (SourceDigits Int (SourceDigits)) * 100
SourceDigits = Int (SourceDigits)
STRNG = SourceDigits
STRNG_len = Len (STRNG)
For i = 1 To 9 - STRNG_len Step 1
STRNG = 0 & STRNG
Next i
For i = 9 To 9 - STRNG_len + 1 Step -1
CHAR = Mid (STRNG, i, 1)
If CHAR = Then GoTo end_c
If i = 2 Or i = 5 Or i = 8 Then
IF CHAR = 1 Then
CHAR = Mid (STRNG, i, 2)
Select Case CHAR
Case 10
Prom =
Case 11
Prom =
Case 12
Prom =
Case 13
Prom =
Case 14
Prom =
Case 15
Prom =
Case 16
Prom =
Case 17
Prom =
Case 18
Prom =
Case 19
Prom =
End Select
Else If char Not = 1
Select Case CHAR
Case 0
Prom =
Case 2
Prom =
Case 3
Prom =
Case 4
Prom =
Case 5
Prom =
Case 6
Prom =
Case 7
Prom =
Case 8
Prom =
Case 9
Prom =
End Select
End If
End If
If i = 1 Or i = 4 Or i = 7 Then
Select Case CHAR
Case 0
Prom =
Case 1
Prom =
Case 2
Prom =
Case 3
Prom =
Case 4
Prom =
Case 5
Prom =
Case 6
Prom =
Case 7
Prom =
Case 9
Prom =
End Select
End If
If i = 3 Or i = 6 Or i = 9 Then
If i = 9 And Mid (STRNG, i - 1, 1) = 1 Then
Result = & Result
GoTo end_c
End If
If i = 3 And Mid (STRNG, i - 1, 1) = 1 Then
Result = & Result
GoTo end_c
End If
If i = 6 And Mid (STRNG, i - 1, 1) = 1 Then
Result = & Result
GoTo end_c
End If
Select Case CHAR
Case 0
Prom =
Case 1
If i = 6 Then
Prom =
Else
Prom =
End If
Case 2
If i = 6 Then
Prom =
Else
Prom =
End If
Case 3
Prom =
Case 4
Prom =
Case 5
Prom =
Case 6
Prom =
Case 7
Prom =
Case 8
Prom =
Case 9
Prom =
End Select
End If
Select Case i
Case 3
Select Case CHAR
Case 1
Result = & Result
Case 2 , 3, 4
Result = & Result
Case 5, 6, 7, 8 , 9
Result = & Result
Case 0
If STRNG_len > 6 Then
Result = & Result
End If
End Select
Case 6
Select Case CHAR
Case 1
Result = & Result
Case 2, 3, 4
Result = & Result
Case 5, 6, 7, 8 , 9
Result = & Result
Case 0
If STRNG_len > 3 Then
Result = & Result
End If
End Select
Case 9
Select Case CHAR
Case 1
Result = & Result
Case 2 , 3, 4
Result = & Result
Case 0, 5, 6, 7 , 8 , 9
Result = & Result
End Select
End Select
Result = Prom & Result
end_c:
Next i
Result = Format(Mid(Result, 1, 1), > ) & Mid (Result, 2)
= Result & Format (SourceDigTail, 00) & .
End Function