Convertir Numeros a Letras En Excel

Páginas: 3 (696 palabras) Publicado: 2 de abril de 2012
Function Nlet(Number As Double, Optional Kurrencys As String, Optional Kurrency As String) As String

If Kurrencys = "" Then
Kurrencys = "PESOS"
Kurrency = "PESO"
End If
If Kurrency = "" ThenKurrency = Kurrencys

Const MinNum = 0#
Const MaxNum = 4294967295.99

Dim Result As String
If (Number >= MinNum) And (Number <= MaxNum) Then

Dim Kurrenzy As String
Kurrenzy = KurrencyIf Number >= 2 Then Kurrenzy = Kurrencys

Result = RecurseNumber((Fix(Number)))

If Round((Number - Fix(Number)) * 100) < 10 Then
Result = " (" + Result + " " + Kurrenzy + " 0" +Mid(Str(Round((Number - Fix(Number)) * 100)), 2, 1) + "/100 M.N.)"
Else
Result = " (" + Result + " " + Kurrenzy + " " + Mid(Str(Round((Number - Fix(Number)) * 100)), 2, 2) + "/100 M.N.)"
End If
Else
Result= "Error, verifique la cantidad."
End If

Nlet = Result

End Function

Function RecurseNumber(N As Long) As String

Dim Numbers, Tenths, Hundrens
Numbers = Array("CERO", "UN", "DOS","TRES", "CUATRO", "CINCO", "SEIS", "SIETE", "OCHO", "NUEVE", "DIEZ", "ONCE", "DOCE", "TRECE", "CATORCE", "QUINCE", "DIECISÉIS", "DIECISIETE", "DIECIOCHO", "DIECINUEVE", "VEINTE", _
"VEINTIÚN", "VEINTIDÓS","VEINTITRÉS", "VEINTICUATRO", "VEINTICINCO", "VEINTISÉIS", "VEINTISIETE", "VEINTIOCHO", "VEINTINUEVE")
Tenths = Array("CERO", "DIEZ", "VEINTE", "TREINTA", "CUARENTA", "CINCUENTA", "SESENTA","SETENTA", "OCHENTA", "NOVENTA", "CIEN")
Hundrens = Array("CERO", "CIENTO", "DOSCIENTOS", "TRESCIENTOS", "CUATROCIENTOS", "QUINIENTOS", "SEISCIENTOS", "SETECIENTOS", "OCHOCIENTOS", "NOVECIENTOS")

DimResult As String
Select Case N
Case 0
Result = ""
Case 1 To 29
Result = Numbers(N)
Case 30 To 100
Result = Tenths(N \ 10) + IIf(N Mod 10 <> 0, " Y " + RecurseNumber(N Mod 10), "")
Case 101To 999
Result = Hundrens(N \ 100) + IIf(N Mod 100 <> 0, " " + RecurseNumber(N Mod 100), "")
Case 1000 To 999999
Result = RecurseNumber(N \ 1000) + " MIL" + IIf(N Mod 1000 <> 0, " " +...
Leer documento completo

Regístrate para leer el documento completo.

Estos documentos también te pueden resultar útiles

  • Convertir Numeros A Letras En Excel
  • convertir numero a letra en excel
  • convertir-numeros-a-letras-en-excel
  • formula para convertir numeros a letras en excel
  • convertir numeros a letras
  • Convertir numeros en ltras excel
  • convertir numeros a letras funcion()
  • Convertir Numeros A Letras

Conviértase en miembro formal de Buenas Tareas

INSCRÍBETE - ES GRATIS