tag:blogger.com,1999:blog-2823740144792029764.post3396407428651227536..comments2024-03-22T10:46:45.622-06:00Comments on El blog de Luis Reyes: Macro para pasar de números a letras - VBA Excel Luis Reyeshttp://www.blogger.com/profile/16705500235577127575noreply@blogger.comBlogger25125tag:blogger.com,1999:blog-2823740144792029764.post-85088746488153926112022-04-19T10:10:54.242-05:002022-04-19T10:10:54.242-05:00Buenos dias
Al utilizar la macro el numero es est...Buenos dias <br />Al utilizar la macro el numero es este 6749,62 y me lee seis mil setecientos cuarenta y nueve 62/100.<br />Habría forma de cambiar el 62/100 por "con sesenta y dos"<br /><br />muchas gracias <br />Anonymoushttps://www.blogger.com/profile/00862796626475355305noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-83327854304571389392022-03-22T10:52:11.347-06:002022-03-22T10:52:11.347-06:00tienes que cambiar esto:
NumLetras = Trim(NumLet...tienes que cambiar esto: <br /> NumLetras = Trim(NumLetras) & " " & Format(Str(Centavos), "00") & "/100 " & IIf(ValorEntero = 1, MonedaSingular, MonedaPlural)<br /><br />por esto:<br /><br /> NumLetras = Trim(NumLetras) & " " & Format(Str(Centavos), "Pesos 00") & "/100 " & IIf(ValorEntero = 1, MonedaSingular, MonedaPlural)Luis Reyeshttps://www.blogger.com/profile/16705500235577127575noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-13090636758732506142022-03-18T10:23:01.955-06:002022-03-18T10:23:01.955-06:00Disculpa como puede hacer para que entes de los ce...Disculpa como puede hacer para que entes de los centavos venga la palabra PESOS<br />Anonymoushttps://www.blogger.com/profile/12264500158104679164noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-37541511327531785402022-01-15T15:24:28.893-06:002022-01-15T15:24:28.893-06:00MUCHAS GRACIASMUCHAS GRACIASAnonymoushttps://www.blogger.com/profile/02946901165289206203noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-27620860800664511512021-11-18T12:43:31.546-06:002021-11-18T12:43:31.546-06:00tienes que buscar "MN" esta al principio...tienes que buscar "MN" esta al principio, y lo cambias.Luis Reyeshttps://www.blogger.com/profile/16705500235577127575noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-36149222057924404132021-11-18T12:01:25.044-06:002021-11-18T12:01:25.044-06:00Hola, si quisiera que al final salga la palabra SO...Hola, si quisiera que al final salga la palabra SOLES, como debo hacer? ya que el resultado me arroja MN al finalAnonymoushttps://www.blogger.com/profile/15661218437177079210noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-26449000759247878262021-07-28T12:12:14.335-05:002021-07-28T12:12:14.335-05:00gracias por tu visita!!gracias por tu visita!!Luis Reyeshttps://www.blogger.com/profile/16705500235577127575noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-81759677684424109812021-07-28T11:52:38.448-05:002021-07-28T11:52:38.448-05:00Es excelente!Es excelente!Anonymoushttps://www.blogger.com/profile/13703856489521941393noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-342203635461727192021-05-28T10:28:54.430-05:002021-05-28T10:28:54.430-05:00te recomiendo concatenar el signo o la palabra que...te recomiendo concatenar el signo o la palabra que quieres que salgaLuis Reyeshttps://www.blogger.com/profile/16705500235577127575noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-84023469781648411812021-05-27T19:21:56.711-05:002021-05-27T19:21:56.711-05:00QUE CAMBIO PODRIA HACER PARA QUE FUNCIONE CON NUME...QUE CAMBIO PODRIA HACER PARA QUE FUNCIONE CON NUMEROS <br />NEGATIVOS?Axel Meneseshttps://www.blogger.com/profile/17139390196404926944noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-90762611508718144352021-04-22T13:47:46.038-05:002021-04-22T13:47:46.038-05:00gracias a ti por tu visita!!gracias a ti por tu visita!!Luis Reyeshttps://www.blogger.com/profile/16705500235577127575noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-75082824029018355602021-04-22T12:37:42.225-05:002021-04-22T12:37:42.225-05:00¡Excelente! gracias por compartir¡Excelente! gracias por compartirBernardo Rinconhttps://www.blogger.com/profile/00165281750948948425noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-53161864401669348282021-03-30T10:27:26.576-06:002021-03-30T10:27:26.576-06:00hola me funciona de maravilla pero cuando cuando t...hola me funciona de maravilla pero cuando cuando tengo cantidades de DOS MILLARDOS no los convierte en letra cual seria la solucionplanificacionhttps://www.blogger.com/profile/07932142842617210775noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-46400731051091973692021-03-09T21:52:28.233-06:002021-03-09T21:52:28.233-06:00Me da mucho gusto que te haya servido, regresa pro...Me da mucho gusto que te haya servido, regresa pronto al blogLuis Reyeshttps://www.blogger.com/profile/16705500235577127575noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-16273985285560794742021-03-09T21:50:12.513-06:002021-03-09T21:50:12.513-06:00Muchas gracias, programa muy eficiente!!!Muchas gracias, programa muy eficiente!!!Adrianhttps://www.blogger.com/profile/00351095451390894208noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-5992544059802244682021-02-22T11:47:46.085-06:002021-02-22T11:47:46.085-06:00de nada, gracias a ti por visitar el blog, vuelve ...de nada, gracias a ti por visitar el blog, vuelve prontoLuis Reyeshttps://www.blogger.com/profile/16705500235577127575noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-66916443686177304232021-02-22T11:46:14.989-06:002021-02-22T11:46:14.989-06:00ME SIRVIO MUCHO, GRACIAS.
ME SIRVIO MUCHO, GRACIAS.<br />Anonymoushttps://www.blogger.com/profile/05662320595527647949noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-88138530460224030682021-02-22T08:49:16.249-06:002021-02-22T08:49:16.249-06:00al contrario, gracias a ti por visitar el blogal contrario, gracias a ti por visitar el blogLuis Reyeshttps://www.blogger.com/profile/16705500235577127575noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-8215660150344213862021-02-19T22:11:12.361-06:002021-02-19T22:11:12.361-06:00muchas gracias, Excelentemuchas gracias, ExcelenteCheo24https://www.blogger.com/profile/12049990216930422209noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-42456173685516828112021-02-09T19:06:55.577-06:002021-02-09T19:06:55.577-06:00Excelente me da mucho gusto!! Gracias por tu visit...Excelente me da mucho gusto!! Gracias por tu visitaLuis Reyeshttps://www.blogger.com/profile/16705500235577127575noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-37094559604282886672021-02-09T19:06:27.802-06:002021-02-09T19:06:27.802-06:00Me da mucho gusto que te haya funcionado. Gracias ...Me da mucho gusto que te haya funcionado. Gracias por visitaLuis Reyeshttps://www.blogger.com/profile/16705500235577127575noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-35743730673890940342021-02-09T18:22:59.638-06:002021-02-09T18:22:59.638-06:00Lo usé en access y funcionó perfectamente. Lo usé en access y funcionó perfectamente. Anonymoushttps://www.blogger.com/profile/16093299269967037818noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-84321117162766449872021-02-09T18:20:56.173-06:002021-02-09T18:20:56.173-06:00Gracias, gracias. Me sirvió el código 100%Gracias, gracias. Me sirvió el código 100%Anonymoushttps://www.blogger.com/profile/16093299269967037818noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-46317288191806759722021-01-18T16:44:11.245-06:002021-01-18T16:44:11.245-06:00muchas gracias por tu visita.
Saludos!!muchas gracias por tu visita.<br />Saludos!!Luis Reyeshttps://www.blogger.com/profile/16705500235577127575noreply@blogger.comtag:blogger.com,1999:blog-2823740144792029764.post-54195045189264076642021-01-15T23:28:52.511-06:002021-01-15T23:28:52.511-06:00excelente aporte.
excelente aporte.<br />Anonymoushttps://www.blogger.com/profile/02537331316899326222noreply@blogger.com