7/29/2019 Funcin de nmeros a letras en VFP9.docx

1/4

Funcin de nmeros a letras en VFP9

*******************

Function ConvertCurrencyToEnglish( _

ByVal Number As Variant, _

ByVal CurrentMoney As Variant _

) As String

Dim s As String

Dim Temp As String

Dim IntPart As String

Dim Cents As String

Dim DecimalPlace, Count

ReDim Place(9) As String

Place(2) = " Thousand "

Place(3) = " Million "

Place(4) = " Billion "

Place(5) = " Trillion "

'//Convert s to a string, trimming extra spaces.

s = Format(Val(Number), "0.00")

DecimalPlace = InStr(s, Dot)

'//If we find decimal place...

If DecimalPlace > 0 Then

'//Convert cents

Temp = Left$(Mid$(s, DecimalPlace + 1) & "00", 2)

Cents = ConvertTens(Temp)

'//Strip off cents from remainder to convert.

s = Trim$(Left$(s, DecimalPlace - 1))

End If

Count = 1

Do Until s = Void

'//Convert last 3 digits of s to English IntPart.

Temp = ConvertHundreds(Right$(s, 3))

If Len(Temp) Then IntPart = Temp & Place(Count) & IntPart

7/29/2019 Funcin de nmeros a letras en VFP9.docx

2/4

If Len(s) > 3 Then

'//Remove last 3 converted digits from s.

s = Left$(s, Len(s) - 3)

Else

s = Void

End If

Count = Count + 1

Loop

'//Clean up IntPart.

Select Case IntPart

Case Void

IntPart = "No " & CurrentMoney

Case "One"

IntPart = "One " & Singular(CStr(CurrentMoney))

Case Else

IntPart = IntPart & " " & CurrentMoney

End Select

'//Clean up cents.

Select Case Cents

Case Void

Cents = " And No Cents"

Case "One"

Cents = " And One Cent"

Case Else

Cents = " And " & Cents & " Cents"

End Select

ConvertCurrencyToEnglish = IntPart & Cents

End Function

Private Function ConvertHundreds(ByVal MyNumber As Variant) As String

Dim rtn As String

'//Exit if there is nothing to convert.

If Val(MyNumber) = 0 Then Exit Function

'//Append leading zeros to number.

MyNumber = Right$("000" & MyNumber, 3)

'//Do we have a hundreds place digit to convert?

7/29/2019 Funcin de nmeros a letras en VFP9.docx

3/4

If Not Left$(MyNumber, 1) = "0" Then

rtn = ConvertDigit(Left$(MyNumber, 1)) & " Hundred "

End If

'//Do we have a tens place digit to convert?

If Not Mid$(MyNumber, 2, 1) = "0" Then

rtn = rtn & ConvertTens(Mid$(MyNumber, 2))

Else

'//If not, then convert the ones place digit.

rtn = rtn & ConvertDigit(Mid$(MyNumber, 3))

End If

ConvertHundreds = Trim$(rtn)

End Function

Private Function ConvertTens(ByVal MyTens As Variant) As String

Dim rtn As String

'//Is value between 10 and 19?

If Val(Left$(MyTens, 1)) = 1 Then

Select Case Val(MyTens)

Case 10: rtn = "Ten"

Case 11: rtn = "Eleven"

Case 12: rtn = "Twelve"

Case 13: rtn = "Thirteen"

Case 14: rtn = "Fourteen"

Case 15: rtn = "Fifteen"

Case 16: rtn = "Sixteen"

Case 17: rtn = "Seventeen"

Case 18: rtn = "Eighteen"

Case 19: rtn = "Nineteen"

Case Else

End Select

Else

'//.. otherwise it's between 20 and 99.

Select Case Val(Left$(MyTens, 1))

Case 2: rtn = "Twenty "

Case 3: rtn = "Thirty "

Case 4: rtn = "Forty "

Case 5: rtn = "Fifty "

Case 6: rtn = "Sixty "

Case 7: rtn = "Seventy "

7/29/2019 Funcin de nmeros a letras en VFP9.docx

4/4

Case 8: rtn = "Eighty "

Case 9: rtn = "Ninety "

Case Else

End Select

'//Convert ones place digit.

rtn = rtn & ConvertDigit(Right$(MyTens, 1))

End If

ConvertTens = rtn

End Function

Private Function ConvertDigit(ByVal MyDigit As Variant) As String

Select Case Val(MyDigit)

Case 1: ConvertDigit = "One"

Case 2: ConvertDigit = "Two"

Case 3: ConvertDigit = "Three"

Case 4: ConvertDigit = "Four"

Case 5: ConvertDigit = "Five"

Case 6: ConvertDigit = "Six"

Case 7: ConvertDigit = "Seven"

Case 8: ConvertDigit = "Eight"

Case 9: ConvertDigit = "Nine"

Case Else: ConvertDigit = Void

End Select

End Function

***************

Saludos desde Mrida, Yuc, mex

cesarpech@sji.com.mx