Re: Number2Text

From: Date: Tue, 16 Mar 2004 20:40:58 +0000
Subject: Re: Number2Text
Groups: php.general.es 
Request: Send a blank email to general-es+get-46704@lists.php.net to get a copy of this message
esta es una funcion que me pasó un amigo la puedes revisar ..... depronto te sirva Function ConvertCurrencyToEnglish(ByVal MyNumber) Dim Temp Dim Dollars, Cents Dim DecimalPlace, Count Dim PLACE(5) PLACE(2) = " Mil" PLACE(3) = " Millon" PLACE(4) = " Billon" PLACE(5) = " Trillon" ' ConvertMyNumber to a string, trimming extra spaces. If IsNull(MyNumber) Then MyNumber = 0 End If MyNumber = Trim(Str(MyNumber)) ' Find decimal Place. DecimalPlace = InStr(MyNumber, ".") ' If we find decimal place... If DecimalPlace > 0 Then ' Convert cents Temp = Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2) Cents = ConvertTens(Temp) ' Strip off cents from remainder to convert. MyNumber = Trim(Left(MyNumber, DecimalPlace - 1)) End If Count = 1 Do While MyNumber <> "" ' Convert last 3 digits of MyNumber to English dollars. Temp = ConvertHundreds(Right(MyNumber, 3)) If Temp <> "" Then If Count > 2 And MyNumber > 1 Then Dollars = Temp & PLACE(Count) & "es " & Dollars Else Dollars = Temp & PLACE(Count) & " " & Dollars End If If Len(MyNumber) > 3 Then ' Remove last 3 converted digits from MyNumber. MyNumber = Left(MyNumber, Len(MyNumber) - 3) Else MyNumber = "" End If Count = Count + 1 ElseIf Len(MyNumber) > 3 Then MyNumber = Left(MyNumber, Len(MyNumber) - 3) Count = Count + 1 Else MyNumber = "" End If Loop ' Clean up dollars. Select Case Dollars Case "": Dollars = "00/100 pesos" Case "Un ": Dollars = "Un Pesos" Case Else Dollars = Dollars & " Pesos" End Select ' Clean up cents. Select Case Cents Case "": Cents = " Con 00/100 Centavos" Case "Un": Cents = " Con Un Centavo" Case Else Cents = " Con " & Cents & " Centavos" End Select ConvertCurrencyToEnglish = Dollars & Cents MsgBox ConvertCurrencyToEnglish End Function Private Function ConvertDigit(ByVal MyDigit, Caso As Integer, Caso1 As Integer) Select Case Caso Case 1: Select Case Val(MyDigit) Case 1: ConvertDigit = "Un" Case 2: ConvertDigit = "Dos" Case 3: ConvertDigit = "Tres" Case 4: ConvertDigit = "Cuatro" Case 5: ConvertDigit = "Cinco" Case 6: ConvertDigit = "Seis" Case 7: ConvertDigit = "Siete" Case 8: ConvertDigit = "Ocho" Case 9: ConvertDigit = "Nueve" Case Else: ConvertDigit = "" End Select Case 2: Select Case Val(MyDigit) Case 1: If Caso1 = 0 Then ConvertDigit = "Cien " Else ConvertDigit = "Ciento " End If Case 2: ConvertDigit = "Doscientos " Case 3: ConvertDigit = "Trescientos " Case 4: ConvertDigit = "Cuatrocientos " Case 5: ConvertDigit = "Quinientos " Case 6: ConvertDigit = "Seiscientos " Case 7: ConvertDigit = "Setecientos " Case 8: ConvertDigit = "Ochocientos " Case 9: ConvertDigit = "Novecientos " Case Else: ConvertDigit = "" End Select End Select End Function Private Function ConvertHundreds(ByVal MyNumber) Dim Result 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? If Left(MyNumber, 1) <> "0" Then Result = ConvertDigit(Left(MyNumber, 1), 2, Val(Right(MyNumber, 2))) & "" End If ' Do we have a tens place digit to convert? If Mid(MyNumber, 2, 1) <> "0" Then Result = Result & ConvertTens(Mid(MyNumber, 2)) Else ' If not, then convert the ones place digit. Result = Result & ConvertDigit(Mid(MyNumber, 3), 1, 0) End If ConvertHundreds = Trim(Result) End Function Private Function ConvertTens(ByVal MyTens) Dim Result As String If Val(Left(MyTens, 1)) = 1 Then Select Case Val(MyTens) Case 10: Result = "Diez" Case 11: Result = "Once" Case 12: Result = "Doce" Case 13: Result = "Trece" Case 14: Result = "Catorce" Case 15: Result = "Quince" Case 16: Result = "Dieciseis" Case 17: Result = "Diecisiete" Case 18: Result = "Dieciocho" Case 19: Result = "Diecinueve" Case Else End Select Else Select Case Val(Left(MyTens, 1)) Case 2: Result = "Veinte y " Case 3: Result = "Treinta y " Case 4: Result = "Cuarenta y " Case 5: Result = "Cincuenta y " Case 6: Result = "Sesenta y " Case 7: Result = "Setenta y " Case 8: Result = "Ochenta y " Case 9: Result = "Noventa y " Case Else End Select If ConvertDigit(Right(MyTens, 1), 1, 0) = "" Then Result = Mid(Result, 1, Len(Result) - 2) End If Result = Result & ConvertDigit(Right(MyTens, 1), 1, 0) End If ConvertTens = Result End Function -- ______________________________________________________ Obtenga su E-mail gratis en http://e-mail.colombia.com Llegó la Fórmula 1 a Colombia.com http://www.colombia.com/formula1/ Visita http://www.colombia.com El portal que une a los colombianos en el mundo Powered by Outblaze

« previous php.general.es (#46704) next »