fbpx

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

Formula personalizada en excel numeros a letrasFó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).

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

IMPORTANTE – ACTUALIZACIÓN A FEBRERO 2016

La ruta donde debes colocar el arhivo .xla que descarás lineas abajo es:

  • %homepath%\Datos de programa\Microsoft\addins
  • %homepath%\AppData\Roaming\Microsoft\addins
  • %homepath%\Datos de programa\Microsoft\complementos
  • %homepath%\AppData\Roaming\Microsoft\complementos

Intenta una de ellas, lo he actualizado hasta excel 2016, a mi personalmente me funciona la segunda.

menu ejecutar ruta para complemento de excel

MIRA ESTE VIDEO (Pronto lo actualizaré)

DESCARGA EL ARCHIVO

Para versiones de excel 2010 – 2013 – 2016 ó superior

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

Para versiones de excel 2007 – 2003 – ó inferior

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

SUSCRÍBETE GRATIS

Te convertiré en un experto en Excel, tengo la experiencia y todo el material que necesitas, mi ayuda es totalmente gratuita.

Suscríbete

Agrega tu comentario

Comentarios
  1. Posted by Maira
    • Posted by Gustavo A. Sebastiani Cépeda
  2. Posted by Diana
    • Posted by Gustavo A. Sebastiani Cépeda
  3. Posted by Juan Mendoza
    • Posted by Gustavo A. Sebastiani Cépeda
  4. Posted by Juan Mendoza
    • Posted by Gustavo A. Sebastiani Cépeda
  5. Posted by miguel
    • Posted by Gustavo A. Sebastiani Cépeda
  6. Posted by moises tagle
    • Posted by Gustavo A. Sebastiani Cépeda
  7. Posted by Javier
    • Posted by Gustavo A. Sebastiani Cépeda
  8. Posted by Luison
    • Posted by Gustavo A. Sebastiani Cépeda
  9. Posted by isai quispe
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by lemm
        • Posted by Gustavo A. Sebastiani Cépeda
  10. Posted by Claudio
    • Posted by Gustavo A. Sebastiani Cépeda
  11. Posted by Maria Elena
    • Posted by Gustavo A. Sebastiani Cépeda
  12. Posted by Joel
    • Posted by Gustavo A. Sebastiani Cépeda
  13. Posted by Ernesto Bernal
    • Posted by Gustavo A. Sebastiani Cépeda
  14. Posted by Claudia
    • Posted by Gustavo A. Sebastiani Cépeda
  15. Posted by Alfredo Hernandez Osuna
    • Posted by Gustavo A. Sebastiani Cépeda
  16. Posted by jorge Pino
    • Posted by Gustavo A. Sebastiani Cépeda
  17. Posted by Marianela Hernandez
    • Posted by Gustavo A. Sebastiani Cépeda
  18. Posted by erwin
    • Posted by Gustavo A. Sebastiani Cépeda
  19. Posted by Néstor Maqueda
    • Posted by Gustavo A. Sebastiani Cépeda
  20. Posted by Iván Navas Mendoza
    • Posted by Gustavo A. Sebastiani Cépeda
  21. Posted by Alfredo Hernandez Osuna
    • Posted by Gustavo A. Sebastiani Cépeda
  22. Posted by Wilson Vásquez
    • Posted by Gustavo A. Sebastiani Cépeda
  23. Posted by Wilson Alcala
    • Posted by Gustavo A. Sebastiani Cépeda
  24. Posted by Mario
    • Posted by Gustavo A. Sebastiani Cépeda
  25. Posted by NELSON GOMEZ - REPUBLICA DOMINICANA
    • Posted by Gustavo A. Sebastiani Cépeda
  26. Posted by Juan Carlos
    • Posted by Gustavo A. Sebastiani Cépeda
  27. Posted by Carlos
    • Posted by Gustavo A. Sebastiani Cépeda
  28. Posted by Ale
    • Posted by Gustavo A. Sebastiani Cépeda
  29. Posted by Hugo Acosta
    • Posted by Gustavo A. Sebastiani Cépeda
  30. Posted by JOSE
    • Posted by Gustavo A. Sebastiani Cépeda
  31. Posted by Eduardo
    • Posted by Gustavo A. Sebastiani Cépeda
  32. Posted by Wilver
  33. Posted by Zonavip10
  34. Posted by Antonio
  35. Posted by Rolando
  36. Posted by Sergio Suárez
  37. Posted by omar zacarias amaya palacios
  38. Posted by MARIO ALBERTO RIVERA
  39. Posted by Juan Pocasangre
  40. Posted by Paule
  41. Posted by Caringri
  42. Posted by Julio
  43. Posted by Jaime Cruz
  44. Posted by jose lopez
    • Posted by Robin Solano
  45. Posted by jose flores
  46. Posted by Pedro Benitez
  47. Posted by Carlos Olvera
  48. Posted by Luis Aparicio
  49. Posted by wil acosta
  50. Posted by SILVIA
  51. Posted by RAFAEL DEL SOLAR
  52. Posted by pedro
  53. Posted by MIgue
    • Posted by Robin Solano
  54. Posted by john rodriguez
  55. Posted by efrain
  56. Posted by Nora Tolosa
  57. Posted by Jorge
  58. Posted by HAROL
  59. Posted by STEPHANIE
  60. Posted by Alexis Barboza O.
  61. Posted by Luis Mendoz
  62. Posted by Jaime
  63. Posted by Cristian
  64. Posted by Gisella
  65. Posted by ARIX
  66. Posted by Ernesto Bernal Pinilla
  67. Posted by Gustavo
    • Posted by Robin Solano
  68. Posted by Hector
    • Posted by Robin Solano
  69. Posted by Karla
    • Posted by Robin Solano
  70. Posted by Jose Luis Ruiz aguilar
  71. Posted by Carlos Martínez
  72. Posted by ALEX
  73. Posted by maribel cruz
    • Posted by Robin Solano
  74. Posted by PATRICIA
    • Posted by Robin Solano
  75. Posted by RAQUEL
    • Posted by Robin Solano
      • Posted by andres paez
        • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by ALEJANDRA RODRIGUEZ
  76. Posted by MOnica
  77. Posted by Mayra
    • Posted by Robin Solano
  78. Posted by ALEJANDRO
  79. Posted by Artur
    • Posted by Robin Solano
      • Posted by Enma Valle
  80. Posted by jose quintero
    • Posted by Gustavo A. Sebastiani Cépeda
  81. Posted by Emerson
    • Posted by Gustavo A. Sebastiani Cépeda
  82. Posted by Lupita Garcia
    • Posted by Gustavo A. Sebastiani Cépeda
  83. Posted by Bettsy Guevara
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by mmachadob
  84. Posted by Edgard Guerra
  85. Posted by Jovanny
  86. Posted by walter
  87. Posted by Nathaniel Varela
    • Posted by Gustavo A. Sebastiani Cépeda
  88. Posted by VIKTOR
    • Posted by Robin Solano
  89. Posted by Yaqueline
    • Posted by Gustavo A. Sebastiani Cépeda
  90. Posted by Angel
    • Posted by Gustavo A. Sebastiani Cépeda
  91. Posted by Ricardo
    • Posted by Gustavo A. Sebastiani Cépeda
  92. Posted by Julio
    • Posted by Robin Solano
  93. Posted by Reyna Guerrero
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by ANA
        • Posted by Gustavo A. Sebastiani Cépeda
  94. Posted by laury serrano leon
  95. Posted by Eduardo
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Eduardo
        • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by roigar jose
        • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by xXDancovAXx
        • Posted by Robin Solano
  96. Posted by Javier
    • Posted by Gustavo A. Sebastiani Cépeda
  97. Posted by ALEX
  98. Posted by FRANCISCO
    • Posted by Gustavo A. Sebastiani Cépeda
  99. Posted by Adela
    • Posted by Gustavo A. Sebastiani Cépeda
  100. Posted by Marcial
    • Posted by Gustavo A. Sebastiani Cépeda
  101. Posted by Ana PONCE
    • Posted by Gustavo A. Sebastiani Cépeda
  102. Posted by ruben
    • Posted by Gustavo A. Sebastiani Cépeda
  103. Posted by ABRAHAM VICENTE
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Rodrigo
        • Posted by Gustavo A. Sebastiani Cépeda
  104. Posted by Yeisson
    • Posted by Gustavo A. Sebastiani Cépeda
  105. Posted by Gustavo
    • Posted by Gustavo A. Sebastiani Cépeda
  106. Posted by HIlmer
    • Posted by Gustavo A. Sebastiani Cépeda
  107. Posted by sosa
    • Posted by Gustavo A. Sebastiani Cépeda
  108. Posted by Luis
    • Posted by Gustavo A. Sebastiani Cépeda
  109. Posted by Verónica
    • Posted by Gustavo A. Sebastiani Cépeda
  110. Posted by David Iberico
    • Posted by Gustavo A. Sebastiani Cépeda
  111. Posted by JULIAN
  112. Posted by ERIKA GARIBELLO
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Natalia Guerra
        • Posted by Gustavo A. Sebastiani Cépeda
  113. Posted by KAEMIRC
    • Posted by Gustavo A. Sebastiani Cépeda
  114. Posted by Jorge Alonso
  115. Posted by Howard
  116. Posted by gabriel
  117. Posted by Eumir Perez
    • Posted by Gustavo A. Sebastiani Cépeda
  118. Posted by JorgeAF
  119. Posted by David Mesias
  120. Posted by ALFONSO RUIZ PINZON
    • Posted by Gustavo A. Sebastiani Cépeda
  121. Posted by William
    • Posted by Gustavo A. Sebastiani Cépeda
  122. Posted by vanessa
  123. Posted by Pame
    • Posted by Gustavo A. Sebastiani Cépeda
  124. Posted by Marco Hernpandez
    • Posted by Gustavo A. Sebastiani Cépeda
  125. Posted by david guerrero
    • Posted by Gustavo A. Sebastiani Cépeda
  126. Posted by Carlos Rosado
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Eumir Perez
  127. Posted by francisca romero garcia
    • Posted by Gustavo A. Sebastiani Cépeda
  128. Posted by francisca romero garcia
    • Posted by Gustavo A. Sebastiani Cépeda
  129. Posted by JENNY TORRICO N.
  130. Posted by mARYURI Lagos
    • Posted by Gustavo A. Sebastiani Cépeda
  131. Posted by Ana Maria
    • Posted by Gustavo A. Sebastiani Cépeda
  132. Posted by CECILIA
    • Posted by Gustavo A. Sebastiani Cépeda
  133. Posted by margarita
    • Posted by Gustavo A. Sebastiani Cépeda
  134. Posted by carlos anariba
    • Posted by Gustavo A. Sebastiani Cépeda
  135. Posted by alexiab45
    • Posted by Gustavo A. Sebastiani Cépeda
  136. Posted by LEONELL
    • Posted by Gustavo A. Sebastiani Cépeda
  137. Posted by Martín
  138. Posted by Hector
  139. Posted by Juan Mendoza
  140. Posted by Miguel
  141. Posted by Miguel
  142. Posted by Pedro
  143. Posted by jair coronado
    • Posted by Gustavo A. Sebastiani Cépeda
  144. Posted by LUPITA AMAO
  145. Posted by Danny
    • Posted by Gustavo A. Sebastiani Cépeda
  146. Posted by bet
  147. Posted by Héctor
    • Posted by Gustavo A. Sebastiani Cépeda
  148. Posted by Taniaj
  149. Posted by Juan
  150. Posted by Javier
    • Posted by Gustavo A. Sebastiani Cépeda
  151. Posted by BELISARIO
  152. Posted by Martin Ruiz Fumachi
  153. Posted by JOSEPH
    • Posted by Gustavo A. Sebastiani Cépeda
  154. Posted by cinthia
    • Posted by Gustavo A. Sebastiani Cépeda
  155. Posted by cinthia
    • Posted by Gustavo A. Sebastiani Cépeda
  156. Posted by Miguel Angel Mendoza G
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by JOSE
  157. Posted by Juan Pablo Yaeger
  158. Posted by Manuel roman
  159. Posted by Daniel Vidarte
    • Posted by Gustavo A. Sebastiani Cépeda
  160. Posted by Karla Torrealba
  161. Posted by rita lilia cardenas cardenas
    • Posted by Gustavo A. Sebastiani Cépeda
  162. Posted by Churo
    • Posted by Gustavo A. Sebastiani Cépeda
  163. Posted by MARIANELA
    • Posted by Gustavo A. Sebastiani Cépeda
  164. Posted by Jesus Garcia
  165. Posted by Nohemi Reyes
  166. Posted by ELY
  167. Posted by Florencia
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by raul
    • Posted by Miguel Angel Mendoza
  168. Posted by max nestares
  169. Posted by Florencia
    • Posted by Gustavo A. Sebastiani Cépeda
  170. Posted by Waldree
    • Posted by Gustavo A. Sebastiani Cépeda
  171. Posted by lesly
  172. Posted by Ferdinando
    • Posted by Ferdinando
    • Posted by Gustavo A. Sebastiani Cépeda
  173. Posted by Cesar
  174. Posted by Amanda Vargas A.
  175. Posted by Karin
  176. Posted by guadalupe
  177. Posted by Michael Garcia
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Miguel Angel Mendoza G.
      • Posted by Gustavo A. Sebastiani Cépeda
  178. Posted by Mario
    • Posted by Mario
      • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Gustavo A. Sebastiani Cépeda
  179. Posted by Miguel Angel Mendoza G.
  180. Posted by Patricia
    • Posted by Gustavo A. Sebastiani Cépeda
  181. Posted by Mónica Báez
  182. Posted by Tomas
  183. Posted by Ignacio
  184. Posted by MAURICIO
    • Posted by Gustavo A. Sebastiani Cépeda
  185. Posted by SUSANA
  186. Posted by Samuel Julca
  187. Posted by tonametl
    • Posted by Gustavo A. Sebastiani Cépeda
  188. Posted by mercy
    • Posted by mercy
      • Posted by Gustavo A. Sebastiani Cépeda
  189. Posted by Cinthya
    • Posted by Gustavo A. Sebastiani Cépeda
  190. Posted by Eric Asmad
  191. Posted by NANCY
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by NANCY
        • Posted by NANCY
        • Posted by Gustavo A. Sebastiani Cépeda
  192. Posted by SERGIO VALVERDE
  193. Posted by RUBI
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by silver
  194. 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
  195. Posted by Ruby
  196. Posted by Edwin torres
  197. Posted by Forelcito
    • Posted by Forelcito
      • Posted by Gustavo A. Sebastiani Cépeda
  198. Posted by rafael mendoza
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by JERT
  199. Posted by Fredy
    • Posted by ALex
  200. Posted by STONE
  201. Posted by Camilo Laurence
    • Posted by Gustavo A. Sebastiani Cépeda
  202. Posted by RAMON
  203. Posted by gustavo
  204. Posted by SIRMOA
  205. Posted by marco laurente
  206. Posted by WIL
  207. Posted by Miguel Mendoza
  208. Posted by franchesca
  209. Posted by Alejandro
  210. Posted by Enrique Ramírez
  211. Posted by jeshu
  212. Posted by [email protected]
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Pepe
        • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Pepe
  213. Posted by Alfredo Glez.
  214. Posted by Lixzi
    • Posted by Gustavo A. Sebastiani Cépeda
  215. Posted by Manu Gavilán
  216. Posted by Felix Carrion
    • Posted by VIOLETA
  217. Posted by Abelardo Arteaga
  218. Posted by pepe
  219. Posted by Julio cesar
  220. Posted by RODOLFO
  221. Posted by Sandra
  222. Posted by Federico
  223. Posted by Diana
  224. Posted by Martha
  225. Posted by Camila Cortez
  226. Posted by Cantarell
  227. Posted by Arlen Bismar Caceres
  228. Posted by ELIX OJEDA OJEDA
  229. Posted by w51027860
  230. Posted by HENRY
  231. Posted by omarshimabukuro
  232. Posted by Silvia Avila
  233. Posted by Daniela Garcia
  234. Posted by Karen
  235. Posted by Orlando Guillen Salgado
  236. Posted by José Monterroso
  237. Posted by MARISABEL
  238. Posted by JUAN ANTONIO
  239. Posted by Rosa Luz
  240. Posted by jonathan
  241. Posted by Omar Davila
  242. Posted by Freddy Flores
  243. Posted by Luis Leon
  244. Posted by Richard López Espinoza
  245. Posted by Hernán Mayor