Fórmula Números a letras mas moneda de tu país en Excel

Fórmula Números a letras mas moneda de tu país en Excel: Los que trabajamos en contabilidad alguna vez hemos necesitado expresar en letras algún importe ya sea al facturar alguna venta o realizar alguna operación que involucre dinero; más aún hemos necesitado expresarlo en nuestra moneda ya sea en Dolares, Nuevos Soles, Pesos etc, sin embargo no existe una función definida que nos permita obtener dichos resultados, pero gracias a las macros se puede hacer y la verdad no es complicado entender el codigo. El dia de hoy he realizado una modificación al código original para hacerlo mas interesante y útil.

Algunos de los cambios que he realizado son: El usuario puede ingresar de forma manual la moneda a usar, el conector (“y”, “con”) y el tipo de letras (mayuscula, minuscula, tipo oración).

La sintaxis de la Funcion es esta: =Numeletras(importe,conector,moneda,tipo).

Publicidad

El archivo a descargar es un complemento de excel que contiene una formula personlizada, en el siguiente video explico como instalarlo y usarlo en 3 minutos. (si no ves el video no sabras como instalarlo)

Descargar función Formula en Excel numeros a letras y moneda de tu país.xla

Luego de haber visto el video necesitaras esto:

Excel 2003: %homepath%\Datos de programa\Microsoft\addins
Excel 2007/2010: %homepath%\Datos de programa\Microsoft\complementos

Publicidad

Agrega tu comentario

Comentarios
  1. Posted by francisca romero garcia
    • Posted by Gustavo A. Sebastiani Cépeda
  2. Posted by francisca romero garcia
    • Posted by Gustavo A. Sebastiani Cépeda
  3. Posted by JENNY TORRICO N.
  4. Posted by mARYURI Lagos
    • Posted by Gustavo A. Sebastiani Cépeda
  5. Posted by Ana Maria
    • Posted by Gustavo A. Sebastiani Cépeda
  6. Posted by CECILIA
    • Posted by Gustavo A. Sebastiani Cépeda
  7. Posted by margarita
    • Posted by Gustavo A. Sebastiani Cépeda
  8. Posted by carlos anariba
    • Posted by Gustavo A. Sebastiani Cépeda
  9. Posted by alexiab45
    • Posted by Gustavo A. Sebastiani Cépeda
  10. Posted by LEONELL
    • Posted by Gustavo A. Sebastiani Cépeda
  11. Posted by Martín
  12. Posted by Hector
  13. Posted by Juan Mendoza
  14. Posted by Miguel
  15. Posted by Miguel
  16. Posted by Pedro
  17. Posted by jair coronado
    • Posted by Gustavo A. Sebastiani Cépeda
  18. Posted by LUPITA AMAO
  19. Posted by Danny
    • Posted by Gustavo A. Sebastiani Cépeda
  20. Posted by bet
  21. Posted by Héctor
    • Posted by Gustavo A. Sebastiani Cépeda
  22. Posted by Taniaj
  23. Posted by Juan
  24. Posted by Javier
    • Posted by Gustavo A. Sebastiani Cépeda
  25. Posted by BELISARIO
  26. Posted by Martin Ruiz Fumachi
  27. Posted by JOSEPH
    • Posted by Gustavo A. Sebastiani Cépeda
  28. Posted by cinthia
    • Posted by Gustavo A. Sebastiani Cépeda
  29. Posted by cinthia
    • Posted by Gustavo A. Sebastiani Cépeda
  30. Posted by Miguel Angel Mendoza G
    • Posted by Gustavo A. Sebastiani Cépeda
  31. Posted by Juan Pablo Yaeger
  32. Posted by Manuel roman
  33. Posted by Daniel Vidarte
    • Posted by Gustavo A. Sebastiani Cépeda
  34. Posted by Karla Torrealba
  35. Posted by rita lilia cardenas cardenas
    • Posted by Gustavo A. Sebastiani Cépeda
  36. Posted by Churo
    • Posted by Gustavo A. Sebastiani Cépeda
  37. Posted by MARIANELA
    • Posted by Gustavo A. Sebastiani Cépeda
  38. Posted by Jesus Garcia
  39. Posted by Nohemi Reyes
  40. Posted by ELY
  41. Posted by Florencia
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by raul
    • Posted by Miguel Angel Mendoza
  42. Posted by max nestares
  43. Posted by Florencia
    • Posted by Gustavo A. Sebastiani Cépeda
  44. Posted by Waldree
    • Posted by Gustavo A. Sebastiani Cépeda
  45. Posted by lesly
  46. Posted by Ferdinando
    • Posted by Ferdinando
    • Posted by Gustavo A. Sebastiani Cépeda
  47. Posted by Cesar
  48. Posted by Amanda Vargas A.
  49. Posted by Karin
  50. Posted by guadalupe
  51. Posted by Michael Garcia
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Miguel Angel Mendoza G.
      • Posted by Gustavo A. Sebastiani Cépeda
  52. Posted by Mario
    • Posted by Mario
      • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Gustavo A. Sebastiani Cépeda
  53. Posted by Miguel Angel Mendoza G.
  54. Posted by Patricia
    • Posted by Gustavo A. Sebastiani Cépeda
  55. Posted by Mónica Báez
  56. Posted by Tomas
  57. Posted by Ignacio
  58. Posted by MAURICIO
    • Posted by Gustavo A. Sebastiani Cépeda
  59. Posted by SUSANA
  60. Posted by Samuel Julca
  61. Posted by tonametl
    • Posted by Gustavo A. Sebastiani Cépeda
  62. Posted by mercy
    • Posted by mercy
      • Posted by Gustavo A. Sebastiani Cépeda
  63. Posted by Cinthya
    • Posted by Gustavo A. Sebastiani Cépeda
  64. Posted by Eric Asmad
  65. Posted by NANCY
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by NANCY
        • Posted by NANCY
        • Posted by Gustavo A. Sebastiani Cépeda
  66. Posted by SERGIO VALVERDE
  67. Posted by RUBI
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by silver
  68. Posted by lenin toledo
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by RUBI
        • Posted by Gustavo A. Sebastiani Cépeda
          • Posted by RUBI
          • Posted by Gustavo A. Sebastiani Cépeda
          • Posted by RUBI
  69. Posted by Ruby
  70. Posted by Edwin torres
  71. Posted by Forelcito
    • Posted by Forelcito
      • Posted by Gustavo A. Sebastiani Cépeda
  72. Posted by rafael mendoza
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by JERT
  73. Posted by Fredy
    • Posted by ALex
  74. Posted by STONE
  75. Posted by Camilo Laurence
    • Posted by Gustavo A. Sebastiani Cépeda
  76. Posted by RAMON
  77. Posted by gustavo
  78. Posted by SIRMOA
  79. Posted by marco laurente
  80. Posted by WIL
  81. Posted by Miguel Mendoza
  82. Posted by franchesca
  83. Posted by Alejandro
  84. Posted by Enrique Ramírez
  85. Posted by jeshu
  86. Posted by CHRISTIAN1630@HOTMAIL.COM
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Pepe
        • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Pepe
  87. Posted by Alfredo Glez.
  88. Posted by Lixzi
    • Posted by Gustavo A. Sebastiani Cépeda
  89. Posted by Manu Gavilán
  90. Posted by Felix Carrion
    • Posted by VIOLETA
  91. Posted by Abelardo Arteaga
  92. Posted by pepe
  93. Posted by Julio cesar
  94. Posted by RODOLFO
  95. Posted by Sandra
  96. Posted by Federico
  97. Posted by Diana
  98. Posted by Martha
  99. Posted by Camila Cortez
  100. Posted by Cantarell
  101. Posted by Arlen Bismar Caceres
  102. Posted by ELIX OJEDA OJEDA
  103. Posted by w51027860
  104. Posted by HENRY
  105. Posted by omarshimabukuro
  106. Posted by Silvia Avila
  107. Posted by Daniela Garcia
  108. Posted by Karen
  109. Posted by Orlando Guillen Salgado
  110. Posted by José Monterroso
  111. Posted by MARISABEL
  112. Posted by JUAN ANTONIO
  113. Posted by Rosa Luz
  114. Posted by jonathan
  115. Posted by Omar Davila
  116. Posted by Freddy Flores
  117. Posted by Luis Leon
  118. Posted by Richard López Espinoza
  119. Posted by Hernán Mayor