{"id":1483,"date":"2023-11-15T16:31:45","date_gmt":"2023-11-15T16:31:45","guid":{"rendered":"https:\/\/saibam.com.br\/excel\/?p=1483"},"modified":"2023-12-03T02:04:53","modified_gmt":"2023-12-03T02:04:53","slug":"num-extenso","status":"publish","type":"post","link":"https:\/\/saibam.com.br\/excel\/num-extenso\/","title":{"rendered":"N\u00fam. Extenso"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1483\" class=\"elementor elementor-1483\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0a99f6f e-flex e-con-boxed e-con e-parent\" data-id=\"0a99f6f\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-45ab332 elementor-icon-list--layout-inline elementor-align-center elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"45ab332\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-home\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Home<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/blog\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-blog\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Blog<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/contato\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-contao\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Contato<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/sobre\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-laugh\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Sobre<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/pesquisar-no-site\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-search\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Pesquisar<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f9e9804 e-flex e-con-boxed e-con e-child\" data-id=\"f9e9804\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2dfaff3 elementor-widget elementor-widget-heading\" data-id=\"2dfaff3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Fun\u00e7\u00e3o N\u00fameros por Extenso em VBA<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-bf22e0a e-flex e-con-boxed e-con e-parent\" data-id=\"bf22e0a\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9f86fcf elementor-widget elementor-widget-image\" data-id=\"9f86fcf\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"660\" height=\"337\" src=\"https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/11\/funcao_Numeros-por-Extenso--1024x523.png\" class=\"attachment-large size-large wp-image-1488\" alt=\"\" srcset=\"https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/11\/funcao_Numeros-por-Extenso--1024x523.png 1024w, https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/11\/funcao_Numeros-por-Extenso--300x153.png 300w, https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/11\/funcao_Numeros-por-Extenso--768x393.png 768w, https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/11\/funcao_Numeros-por-Extenso-.png 1166w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e494e11 e-flex e-con-boxed e-con e-parent\" data-id=\"e494e11\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-90860ef elementor-widget elementor-widget-text-editor\" data-id=\"90860ef\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Criar uma fun\u00e7\u00e3o em VBA que converte n\u00fameros em valores por extenso pode ser um pouco complexo, devido \u00e0s regras de numera\u00e7\u00e3o em portugu\u00eas. Abaixo, segue uma fun\u00e7\u00e3o b\u00e1sica que pode converter n\u00fameros inteiros at\u00e9 999. Se voc\u00ea precisar de uma fun\u00e7\u00e3o mais abrangente, que lide com n\u00fameros maiores e decimais, recomendo procurar uma biblioteca espec\u00edfica ou expandir o c\u00f3digo.<\/p>\n<pre><code>\nFunction NumeroPorExtenso(ByVal Numero As Integer) As String\n    Dim Unidades As Variant\n    Dim Dezenas As Variant\n    Dim Centenas As Variant\n    Dim NumExtenso As String\n    Dim Resto As Integer\n\n    ' Arrays de strings para as unidades, dezenas e centenas\n    Unidades = Array(\"\", \"um\", \"dois\", \"tr\u00eas\", \"quatro\", \"cinco\", \"seis\", \"sete\", \"oito\", \"nove\")\n    Dezenas = Array(\"\", \"dez\", \"vinte\", \"trinta\", \"quarenta\", \"cinquenta\", \"sessenta\", \"setenta\", \"oitenta\", \"noventa\")\n    Centenas = Array(\"\", \"cento\", \"duzentos\", \"trezentos\", \"quatrocentos\", \"quinhentos\", \"seiscentos\", \"setecentos\", \"oitocentos\", \"novecentos\")\n\n    ' Verificar centenas\n    If Numero = 100 Then\n        NumExtenso = \"cem\"\n    Else\n        NumExtenso = Centenas(Numero \\ 100)\n    End If\n\n    Resto = Numero Mod 100\n\n    ' Verificar dezenas\n    If Resto &gt;= 10 And Resto &lt;= 19 Then\n        NumExtenso = NumExtenso &amp; \" \" &amp; Array(\"dez\", \"onze\", \"doze\", \"treze\", \"quatorze\", \"quinze\", \"dezesseis\", \"dezessete\", \"dezoito\", \"dezenove\")(Resto - 10)\n    Else\n        NumExtenso = NumExtenso &amp; \" \" &amp; Dezenas(Resto \\ 10)\n        Resto = Resto Mod 10\n    End If\n\n    ' Verificar unidades\n    NumExtenso = NumExtenso &amp; \" \" &amp; Unidades(Resto)\n\n    ' Remover espa\u00e7os extras\n    NumeroPorExtenso = Trim(Replace(NumExtenso, \"  \", \" \"))\nEnd Function\n\nSub ConverterNumeroPorExtenso()\n    Dim Numero As Integer\n    Dim Extenso As String\n\n    ' L\u00ea o n\u00famero da c\u00e9lula A1\n    Numero = ThisWorkbook.Sheets(1).Range(\"A1\").Value\n\n    ' Converte para extenso\n    Extenso = NumeroPorExtenso(Numero)\n\n    ' Escreve o resultado na c\u00e9lula A2\n    ThisWorkbook.Sheets(1).Range(\"A2\").Value = Extenso\nEnd Sub\n\n\n\n<\/code><\/pre>\n<p>Abra o Excel e pressione ALT + F11 para abrir o Editor do VBA.<br \/><span style=\"font-size: 15px; color: var( --e-global-color-text ); text-align: var(--text-align);\">No menu &#8220;Inserir&#8221;, escolha &#8220;M\u00f3dulo&#8221; para criar um novo m\u00f3dulo.<br \/><\/span><span style=\"font-size: 15px; color: var( --e-global-color-text ); text-align: var(--text-align);\">Cole o c\u00f3digo acima no m\u00f3dulo.<br \/><\/span><span style=\"font-size: 15px; color: var( --e-global-color-text ); text-align: var(--text-align);\">Execute a sub-rotina ConverterNumeroPorExtenso com um n\u00famero na c\u00e9lula A1 da primeira planilha.<br \/><\/span><span style=\"font-size: 15px; color: var( --e-global-color-text ); text-align: var(--text-align);\">Este c\u00f3digo ir\u00e1 ler o n\u00famero da c\u00e9lula A1, converter para por extenso e colocar o resultado na c\u00e9lula A2. Note que este c\u00f3digo \u00e9 limitado a n\u00fameros inteiros at\u00e9 999. Para n\u00fameros maiores ou com decimais, a fun\u00e7\u00e3o precisaria ser significativamente expandida.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ee1908c elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"ee1908c\" data-element_type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Caso queira receber esse arquivo Excel, contendo essa fun\u00e7\u00e3o, \u00e9 s\u00f3 enviar um e-mail <br \/>solicitando para o endere\u00e7o <br \/><strong>marmitanao@gmail.com<br \/><br \/><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9bdc2df e-flex e-con-boxed e-con e-parent\" data-id=\"9bdc2df\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b147a58 e-flex e-con-boxed e-con e-parent\" data-id=\"b147a58\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-cf166ea e-con-full e-flex e-con e-child\" data-id=\"cf166ea\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8a0667e elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"8a0667e\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-geradora-de-cpfs-validos\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Geradora de CPFs em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-geradora-de-cnpjs-validos\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-creative-commons-nd\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Geradora de CNPJs em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.facilitademais.com.br\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-globe-americas\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Site para validar as fun\u00e7\u00f5es geradoras<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-57117f8 e-con-full e-flex e-con e-child\" data-id=\"57117f8\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6305c7b elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"6305c7b\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-geradora-de-cnhs\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-globe-africa\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Geradora de CNHs em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/gerar-senhas-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-wpforms\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Geradora de Senhas em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/gerar-numeros-da-mega-sena\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-hand-point-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Geradora de Mega Sena em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b178054 e-flex e-con-boxed e-con e-parent\" data-id=\"b178054\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3b2791f elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"3b2791f\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-eac2340 e-flex e-con-boxed e-con e-parent\" data-id=\"eac2340\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Home Blog Contato Sobre Pesquisar Fun\u00e7\u00e3o N\u00fameros por Extenso em VBA Criar uma fun\u00e7\u00e3o em VBA que converte n\u00fameros em valores por extenso pode ser um pouco complexo, devido \u00e0s regras de numera\u00e7\u00e3o em portugu\u00eas. Abaixo, segue uma fun\u00e7\u00e3o b\u00e1sica que pode converter n\u00fameros inteiros at\u00e9 999. Se voc\u00ea precisar de uma fun\u00e7\u00e3o mais abrangente, &hellip; <a href=\"https:\/\/saibam.com.br\/excel\/num-extenso\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">N\u00fam. Extenso<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"tpgb_global_settings":"","footnotes":""},"categories":[140],"tags":[75,77,141,138,136,131,130,27,78,128,30,31,32,34,35,36,38,39,40,143,41,79,42,43,44,46,37,29,47,48,49,50,137,51,52,53,54,55,80,144,56,58,60,61,62,63,64,65,66,67,68,69,70,81,71,134,86,87,88,89,90,133,91,92,145,95,96,98,135,100,82,101,73,72,102,103,132,83,104,105,106,107,84,108,109,110,111,112,113,85,115,117,118,119,57,74,120,121,122,28,123,7,11,97,94,124,126,127],"class_list":["post-1483","post","type-post","status-publish","format-standard","hentry","category-funcoes-ninjas","tag-abs","tag-atn","tag-base64-decode","tag-base64-encode","tag-cep","tag-cnh","tag-cnpj","tag-conversao-de-texto-para-numero","tag-cos","tag-cpf","tag-curdir","tag-data","tag-dateadd","tag-datediff","tag-datepart","tag-dateserial","tag-day","tag-doevents","tag-eof","tag-epoch-time","tag-error","tag-exp","tag-fileattr","tag-filedatetime","tag-filelen","tag-freefile","tag-funcao-day","tag-funcao-val","tag-getattr","tag-getobject","tag-getsetting","tag-hora","tag-ie","tag-iif","tag-input","tag-inputbox","tag-instr","tag-instrrev","tag-int","tag-ip","tag-ipmt","tag-isarray","tag-isdate","tag-isempty","tag-ismissing","tag-isnull","tag-isobject","tag-join","tag-lbound","tag-lcase","tag-left","tag-loc","tag-lof","tag-log","tag-ltrim","tag-mega-sena","tag-mid","tag-minute","tag-month","tag-monthname","tag-msgbox","tag-nomes","tag-now","tag-nper","tag-numeros-por-extenso","tag-pmt","tag-ppmt","tag-qbcolor","tag-rg","tag-right","tag-rnd","tag-round","tag-rtrim","tag-rtrim-e-trim","tag-second","tag-seek","tag-senhas","tag-sgn","tag-shell","tag-space","tag-spc","tag-split","tag-sqr","tag-strcomp","tag-strconv","tag-string","tag-strreverse","tag-switch","tag-syd","tag-tan","tag-time","tag-timer","tag-timeserial","tag-timevalue","tag-tir","tag-trim","tag-typename","tag-ubound","tag-ucase","tag-val","tag-vartype","tag-vba","tag-visual-basic-for-applications","tag-vp","tag-vpl","tag-weekday","tag-weekdayname","tag-year"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>N\u00fam. Extenso - Saibam<\/title>\n<meta name=\"description\" content=\"Criar uma fun\u00e7\u00e3o em VBA que converte n\u00fameros em valores por extenso pode ser um pouco complexo, devido \u00e0s regras de numera\u00e7\u00e3o em portugu\u00eas. Abaixo, segue uma fun\u00e7\u00e3o b\u00e1sica que pode converter n\u00fameros inteiros at\u00e9 999. Se voc\u00ea precisar de uma fun\u00e7\u00e3o mais abrangente, que lide com n\u00fameros maiores e decimais, recomendo procurar uma biblioteca espec\u00edfica ou expandir o c\u00f3digo.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/saibam.com.br\/excel\/num-extenso\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"N\u00fam. Extenso - Saibam\" \/>\n<meta property=\"og:description\" content=\"Criar uma fun\u00e7\u00e3o em VBA que converte n\u00fameros em valores por extenso pode ser um pouco complexo, devido \u00e0s regras de numera\u00e7\u00e3o em portugu\u00eas. Abaixo, segue uma fun\u00e7\u00e3o b\u00e1sica que pode converter n\u00fameros inteiros at\u00e9 999. Se voc\u00ea precisar de uma fun\u00e7\u00e3o mais abrangente, que lide com n\u00fameros maiores e decimais, recomendo procurar uma biblioteca espec\u00edfica ou expandir o c\u00f3digo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/saibam.com.br\/excel\/num-extenso\/\" \/>\n<meta property=\"og:site_name\" content=\"Saibam\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-15T16:31:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T02:04:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/11\/funcao_Numeros-por-Extenso--1024x523.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/saibam.com.br\/excel\/num-extenso\/\",\"url\":\"https:\/\/saibam.com.br\/excel\/num-extenso\/\",\"name\":\"N\u00fam. Extenso - Saibam\",\"isPartOf\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/num-extenso\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/num-extenso\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/11\/funcao_Numeros-por-Extenso--1024x523.png\",\"datePublished\":\"2023-11-15T16:31:45+00:00\",\"dateModified\":\"2023-12-03T02:04:53+00:00\",\"author\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\"},\"description\":\"Criar uma fun\u00e7\u00e3o em VBA que converte n\u00fameros em valores por extenso pode ser um pouco complexo, devido \u00e0s regras de numera\u00e7\u00e3o em portugu\u00eas. Abaixo, segue uma fun\u00e7\u00e3o b\u00e1sica que pode converter n\u00fameros inteiros at\u00e9 999. Se voc\u00ea precisar de uma fun\u00e7\u00e3o mais abrangente, que lide com n\u00fameros maiores e decimais, recomendo procurar uma biblioteca espec\u00edfica ou expandir o c\u00f3digo.\",\"breadcrumb\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/num-extenso\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/saibam.com.br\/excel\/num-extenso\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/saibam.com.br\/excel\/num-extenso\/#primaryimage\",\"url\":\"https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/11\/funcao_Numeros-por-Extenso-.png\",\"contentUrl\":\"https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/11\/funcao_Numeros-por-Extenso-.png\",\"width\":1166,\"height\":596},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/saibam.com.br\/excel\/num-extenso\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/saibam.com.br\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"N\u00fam. Extenso\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\",\"url\":\"https:\/\/saibam.com.br\/excel\/\",\"name\":\"Saibam\",\"description\":\"Excel Macros VBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/saibam.com.br\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/saibam.com.br\/excel\"],\"url\":\"https:\/\/saibam.com.br\/excel\/author\/admin-2\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"N\u00fam. Extenso - Saibam","description":"Criar uma fun\u00e7\u00e3o em VBA que converte n\u00fameros em valores por extenso pode ser um pouco complexo, devido \u00e0s regras de numera\u00e7\u00e3o em portugu\u00eas. Abaixo, segue uma fun\u00e7\u00e3o b\u00e1sica que pode converter n\u00fameros inteiros at\u00e9 999. Se voc\u00ea precisar de uma fun\u00e7\u00e3o mais abrangente, que lide com n\u00fameros maiores e decimais, recomendo procurar uma biblioteca espec\u00edfica ou expandir o c\u00f3digo.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/saibam.com.br\/excel\/num-extenso\/","og_locale":"pt_PT","og_type":"article","og_title":"N\u00fam. Extenso - Saibam","og_description":"Criar uma fun\u00e7\u00e3o em VBA que converte n\u00fameros em valores por extenso pode ser um pouco complexo, devido \u00e0s regras de numera\u00e7\u00e3o em portugu\u00eas. Abaixo, segue uma fun\u00e7\u00e3o b\u00e1sica que pode converter n\u00fameros inteiros at\u00e9 999. Se voc\u00ea precisar de uma fun\u00e7\u00e3o mais abrangente, que lide com n\u00fameros maiores e decimais, recomendo procurar uma biblioteca espec\u00edfica ou expandir o c\u00f3digo.","og_url":"https:\/\/saibam.com.br\/excel\/num-extenso\/","og_site_name":"Saibam","article_published_time":"2023-11-15T16:31:45+00:00","article_modified_time":"2023-12-03T02:04:53+00:00","og_image":[{"url":"https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/11\/funcao_Numeros-por-Extenso--1024x523.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/saibam.com.br\/excel\/num-extenso\/","url":"https:\/\/saibam.com.br\/excel\/num-extenso\/","name":"N\u00fam. Extenso - Saibam","isPartOf":{"@id":"https:\/\/saibam.com.br\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/saibam.com.br\/excel\/num-extenso\/#primaryimage"},"image":{"@id":"https:\/\/saibam.com.br\/excel\/num-extenso\/#primaryimage"},"thumbnailUrl":"https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/11\/funcao_Numeros-por-Extenso--1024x523.png","datePublished":"2023-11-15T16:31:45+00:00","dateModified":"2023-12-03T02:04:53+00:00","author":{"@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712"},"description":"Criar uma fun\u00e7\u00e3o em VBA que converte n\u00fameros em valores por extenso pode ser um pouco complexo, devido \u00e0s regras de numera\u00e7\u00e3o em portugu\u00eas. Abaixo, segue uma fun\u00e7\u00e3o b\u00e1sica que pode converter n\u00fameros inteiros at\u00e9 999. Se voc\u00ea precisar de uma fun\u00e7\u00e3o mais abrangente, que lide com n\u00fameros maiores e decimais, recomendo procurar uma biblioteca espec\u00edfica ou expandir o c\u00f3digo.","breadcrumb":{"@id":"https:\/\/saibam.com.br\/excel\/num-extenso\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/saibam.com.br\/excel\/num-extenso\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/saibam.com.br\/excel\/num-extenso\/#primaryimage","url":"https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/11\/funcao_Numeros-por-Extenso-.png","contentUrl":"https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/11\/funcao_Numeros-por-Extenso-.png","width":1166,"height":596},{"@type":"BreadcrumbList","@id":"https:\/\/saibam.com.br\/excel\/num-extenso\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/saibam.com.br\/excel\/"},{"@type":"ListItem","position":2,"name":"N\u00fam. Extenso"}]},{"@type":"WebSite","@id":"https:\/\/saibam.com.br\/excel\/#website","url":"https:\/\/saibam.com.br\/excel\/","name":"Saibam","description":"Excel Macros VBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/saibam.com.br\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712","name":"admin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/saibam.com.br\/excel"],"url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/"}]}},"tpgb_featured_images":null,"tpgb_post_meta_info":{"get_date":"Novembro 15, 2023","get_modified_date":"Dezembro 3, 2023","category_list":{"category":[{"term_id":140,"name":"Fun\u00e7\u00f5es Ninjas","slug":"funcoes-ninjas","term_group":0,"term_taxonomy_id":140,"taxonomy":"category","description":"","parent":0,"count":8,"filter":"raw"}],"post_tag":[{"term_id":75,"name":"Abs","slug":"abs","term_group":0,"term_taxonomy_id":75,"taxonomy":"post_tag","description":"","parent":0,"count":71,"filter":"raw"},{"term_id":77,"name":"Atn","slug":"atn","term_group":0,"term_taxonomy_id":77,"taxonomy":"post_tag","description":"","parent":0,"count":70,"filter":"raw"},{"term_id":141,"name":"Base64 Decode","slug":"base64-decode","term_group":0,"term_taxonomy_id":141,"taxonomy":"post_tag","description":"","parent":0,"count":9,"filter":"raw"},{"term_id":138,"name":"Base64 Encode","slug":"base64-encode","term_group":0,"term_taxonomy_id":138,"taxonomy":"post_tag","description":"","parent":0,"count":10,"filter":"raw"},{"term_id":136,"name":"cep","slug":"cep","term_group":0,"term_taxonomy_id":136,"taxonomy":"post_tag","description":"","parent":0,"count":12,"filter":"raw"},{"term_id":131,"name":"cnh","slug":"cnh","term_group":0,"term_taxonomy_id":131,"taxonomy":"post_tag","description":"","parent":0,"count":17,"filter":"raw"},{"term_id":130,"name":"cnpj","slug":"cnpj","term_group":0,"term_taxonomy_id":130,"taxonomy":"post_tag","description":"","parent":0,"count":18,"filter":"raw"},{"term_id":27,"name":"Convers\u00e3o de Texto para N\u00famero","slug":"conversao-de-texto-para-numero","term_group":0,"term_taxonomy_id":27,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":78,"name":"Cos","slug":"cos","term_group":0,"term_taxonomy_id":78,"taxonomy":"post_tag","description":"","parent":0,"count":69,"filter":"raw"},{"term_id":128,"name":"cpf","slug":"cpf","term_group":0,"term_taxonomy_id":128,"taxonomy":"post_tag","description":"","parent":0,"count":19,"filter":"raw"},{"term_id":30,"name":"CurDir","slug":"curdir","term_group":0,"term_taxonomy_id":30,"taxonomy":"post_tag","description":"","parent":0,"count":122,"filter":"raw"},{"term_id":31,"name":"data","slug":"data","term_group":0,"term_taxonomy_id":31,"taxonomy":"post_tag","description":"","parent":0,"count":121,"filter":"raw"},{"term_id":32,"name":"dateadd","slug":"dateadd","term_group":0,"term_taxonomy_id":32,"taxonomy":"post_tag","description":"","parent":0,"count":120,"filter":"raw"},{"term_id":34,"name":"datediff","slug":"datediff","term_group":0,"term_taxonomy_id":34,"taxonomy":"post_tag","description":"","parent":0,"count":119,"filter":"raw"},{"term_id":35,"name":"DatePart","slug":"datepart","term_group":0,"term_taxonomy_id":35,"taxonomy":"post_tag","description":"","parent":0,"count":118,"filter":"raw"},{"term_id":36,"name":"dateserial","slug":"dateserial","term_group":0,"term_taxonomy_id":36,"taxonomy":"post_tag","description":"","parent":0,"count":117,"filter":"raw"},{"term_id":38,"name":"day","slug":"day","term_group":0,"term_taxonomy_id":38,"taxonomy":"post_tag","description":"","parent":0,"count":115,"filter":"raw"},{"term_id":39,"name":"doevents","slug":"doevents","term_group":0,"term_taxonomy_id":39,"taxonomy":"post_tag","description":"","parent":0,"count":113,"filter":"raw"},{"term_id":40,"name":"EOF","slug":"eof","term_group":0,"term_taxonomy_id":40,"taxonomy":"post_tag","description":"","parent":0,"count":111,"filter":"raw"},{"term_id":143,"name":"Epoch Time","slug":"epoch-time","term_group":0,"term_taxonomy_id":143,"taxonomy":"post_tag","description":"","parent":0,"count":8,"filter":"raw"},{"term_id":41,"name":"error","slug":"error","term_group":0,"term_taxonomy_id":41,"taxonomy":"post_tag","description":"","parent":0,"count":110,"filter":"raw"},{"term_id":79,"name":"Exp","slug":"exp","term_group":0,"term_taxonomy_id":79,"taxonomy":"post_tag","description":"","parent":0,"count":68,"filter":"raw"},{"term_id":42,"name":"FileAttr","slug":"fileattr","term_group":0,"term_taxonomy_id":42,"taxonomy":"post_tag","description":"","parent":0,"count":109,"filter":"raw"},{"term_id":43,"name":"FileDateTime","slug":"filedatetime","term_group":0,"term_taxonomy_id":43,"taxonomy":"post_tag","description":"","parent":0,"count":108,"filter":"raw"},{"term_id":44,"name":"FileLen","slug":"filelen","term_group":0,"term_taxonomy_id":44,"taxonomy":"post_tag","description":"","parent":0,"count":107,"filter":"raw"},{"term_id":46,"name":"freefile","slug":"freefile","term_group":0,"term_taxonomy_id":46,"taxonomy":"post_tag","description":"","parent":0,"count":102,"filter":"raw"},{"term_id":37,"name":"fun\u00e7\u00e3o day","slug":"funcao-day","term_group":0,"term_taxonomy_id":37,"taxonomy":"post_tag","description":"","parent":0,"count":115,"filter":"raw"},{"term_id":29,"name":"Fun\u00e7\u00e3o Val","slug":"funcao-val","term_group":0,"term_taxonomy_id":29,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":47,"name":"GetAttr","slug":"getattr","term_group":0,"term_taxonomy_id":47,"taxonomy":"post_tag","description":"","parent":0,"count":99,"filter":"raw"},{"term_id":48,"name":"GetObject","slug":"getobject","term_group":0,"term_taxonomy_id":48,"taxonomy":"post_tag","description":"","parent":0,"count":98,"filter":"raw"},{"term_id":49,"name":"GetSetting","slug":"getsetting","term_group":0,"term_taxonomy_id":49,"taxonomy":"post_tag","description":"","parent":0,"count":97,"filter":"raw"},{"term_id":50,"name":"hora","slug":"hora","term_group":0,"term_taxonomy_id":50,"taxonomy":"post_tag","description":"","parent":0,"count":96,"filter":"raw"},{"term_id":137,"name":"IE","slug":"ie","term_group":0,"term_taxonomy_id":137,"taxonomy":"post_tag","description":"","parent":0,"count":11,"filter":"raw"},{"term_id":51,"name":"iif","slug":"iif","term_group":0,"term_taxonomy_id":51,"taxonomy":"post_tag","description":"","parent":0,"count":95,"filter":"raw"},{"term_id":52,"name":"Input","slug":"input","term_group":0,"term_taxonomy_id":52,"taxonomy":"post_tag","description":"","parent":0,"count":94,"filter":"raw"},{"term_id":53,"name":"InputBox","slug":"inputbox","term_group":0,"term_taxonomy_id":53,"taxonomy":"post_tag","description":"","parent":0,"count":93,"filter":"raw"},{"term_id":54,"name":"InStr","slug":"instr","term_group":0,"term_taxonomy_id":54,"taxonomy":"post_tag","description":"","parent":0,"count":92,"filter":"raw"},{"term_id":55,"name":"InStrRev","slug":"instrrev","term_group":0,"term_taxonomy_id":55,"taxonomy":"post_tag","description":"","parent":0,"count":91,"filter":"raw"},{"term_id":80,"name":"Int","slug":"int","term_group":0,"term_taxonomy_id":80,"taxonomy":"post_tag","description":"","parent":0,"count":67,"filter":"raw"},{"term_id":144,"name":"IP","slug":"ip","term_group":0,"term_taxonomy_id":144,"taxonomy":"post_tag","description":"","parent":0,"count":8,"filter":"raw"},{"term_id":56,"name":"IPmt","slug":"ipmt","term_group":0,"term_taxonomy_id":56,"taxonomy":"post_tag","description":"","parent":0,"count":90,"filter":"raw"},{"term_id":58,"name":"IsArray","slug":"isarray","term_group":0,"term_taxonomy_id":58,"taxonomy":"post_tag","description":"","parent":0,"count":88,"filter":"raw"},{"term_id":60,"name":"IsDate","slug":"isdate","term_group":0,"term_taxonomy_id":60,"taxonomy":"post_tag","description":"","parent":0,"count":87,"filter":"raw"},{"term_id":61,"name":"IsEmpty","slug":"isempty","term_group":0,"term_taxonomy_id":61,"taxonomy":"post_tag","description":"","parent":0,"count":86,"filter":"raw"},{"term_id":62,"name":"IsMissing","slug":"ismissing","term_group":0,"term_taxonomy_id":62,"taxonomy":"post_tag","description":"","parent":0,"count":84,"filter":"raw"},{"term_id":63,"name":"IsNull","slug":"isnull","term_group":0,"term_taxonomy_id":63,"taxonomy":"post_tag","description":"","parent":0,"count":83,"filter":"raw"},{"term_id":64,"name":"IsObject","slug":"isobject","term_group":0,"term_taxonomy_id":64,"taxonomy":"post_tag","description":"","parent":0,"count":81,"filter":"raw"},{"term_id":65,"name":"Join","slug":"join","term_group":0,"term_taxonomy_id":65,"taxonomy":"post_tag","description":"","parent":0,"count":80,"filter":"raw"},{"term_id":66,"name":"LBound","slug":"lbound","term_group":0,"term_taxonomy_id":66,"taxonomy":"post_tag","description":"","parent":0,"count":79,"filter":"raw"},{"term_id":67,"name":"LCase","slug":"lcase","term_group":0,"term_taxonomy_id":67,"taxonomy":"post_tag","description":"","parent":0,"count":78,"filter":"raw"},{"term_id":68,"name":"Left","slug":"left","term_group":0,"term_taxonomy_id":68,"taxonomy":"post_tag","description":"","parent":0,"count":77,"filter":"raw"},{"term_id":69,"name":"LOC","slug":"loc","term_group":0,"term_taxonomy_id":69,"taxonomy":"post_tag","description":"","parent":0,"count":76,"filter":"raw"},{"term_id":70,"name":"LOF","slug":"lof","term_group":0,"term_taxonomy_id":70,"taxonomy":"post_tag","description":"","parent":0,"count":75,"filter":"raw"},{"term_id":81,"name":"Log","slug":"log","term_group":0,"term_taxonomy_id":81,"taxonomy":"post_tag","description":"","parent":0,"count":65,"filter":"raw"},{"term_id":71,"name":"LTrim","slug":"ltrim","term_group":0,"term_taxonomy_id":71,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":134,"name":"mega sena","slug":"mega-sena","term_group":0,"term_taxonomy_id":134,"taxonomy":"post_tag","description":"","parent":0,"count":14,"filter":"raw"},{"term_id":86,"name":"MID","slug":"mid","term_group":0,"term_taxonomy_id":86,"taxonomy":"post_tag","description":"","parent":0,"count":59,"filter":"raw"},{"term_id":87,"name":"Minute","slug":"minute","term_group":0,"term_taxonomy_id":87,"taxonomy":"post_tag","description":"","parent":0,"count":58,"filter":"raw"},{"term_id":88,"name":"Month","slug":"month","term_group":0,"term_taxonomy_id":88,"taxonomy":"post_tag","description":"","parent":0,"count":56,"filter":"raw"},{"term_id":89,"name":"MonthName","slug":"monthname","term_group":0,"term_taxonomy_id":89,"taxonomy":"post_tag","description":"","parent":0,"count":55,"filter":"raw"},{"term_id":90,"name":"MsgBox","slug":"msgbox","term_group":0,"term_taxonomy_id":90,"taxonomy":"post_tag","description":"","parent":0,"count":54,"filter":"raw"},{"term_id":133,"name":"nomes","slug":"nomes","term_group":0,"term_taxonomy_id":133,"taxonomy":"post_tag","description":"","parent":0,"count":15,"filter":"raw"},{"term_id":91,"name":"Now","slug":"now","term_group":0,"term_taxonomy_id":91,"taxonomy":"post_tag","description":"","parent":0,"count":53,"filter":"raw"},{"term_id":92,"name":"NPer","slug":"nper","term_group":0,"term_taxonomy_id":92,"taxonomy":"post_tag","description":"","parent":0,"count":52,"filter":"raw"},{"term_id":145,"name":"n\u00fameros por extenso","slug":"numeros-por-extenso","term_group":0,"term_taxonomy_id":145,"taxonomy":"post_tag","description":"","parent":0,"count":6,"filter":"raw"},{"term_id":95,"name":"Pmt","slug":"pmt","term_group":0,"term_taxonomy_id":95,"taxonomy":"post_tag","description":"","parent":0,"count":50,"filter":"raw"},{"term_id":96,"name":"PPmt","slug":"ppmt","term_group":0,"term_taxonomy_id":96,"taxonomy":"post_tag","description":"","parent":0,"count":49,"filter":"raw"},{"term_id":98,"name":"QBColor","slug":"qbcolor","term_group":0,"term_taxonomy_id":98,"taxonomy":"post_tag","description":"","parent":0,"count":47,"filter":"raw"},{"term_id":135,"name":"rg","slug":"rg","term_group":0,"term_taxonomy_id":135,"taxonomy":"post_tag","description":"","parent":0,"count":13,"filter":"raw"},{"term_id":100,"name":"Right","slug":"right","term_group":0,"term_taxonomy_id":100,"taxonomy":"post_tag","description":"","parent":0,"count":44,"filter":"raw"},{"term_id":82,"name":"Rnd","slug":"rnd","term_group":0,"term_taxonomy_id":82,"taxonomy":"post_tag","description":"","parent":0,"count":64,"filter":"raw"},{"term_id":101,"name":"Round","slug":"round","term_group":0,"term_taxonomy_id":101,"taxonomy":"post_tag","description":"","parent":0,"count":43,"filter":"raw"},{"term_id":73,"name":"rtrim","slug":"rtrim","term_group":0,"term_taxonomy_id":73,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":72,"name":"RTrim e Trim","slug":"rtrim-e-trim","term_group":0,"term_taxonomy_id":72,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":102,"name":"Second","slug":"second","term_group":0,"term_taxonomy_id":102,"taxonomy":"post_tag","description":"","parent":0,"count":42,"filter":"raw"},{"term_id":103,"name":"Seek","slug":"seek","term_group":0,"term_taxonomy_id":103,"taxonomy":"post_tag","description":"","parent":0,"count":41,"filter":"raw"},{"term_id":132,"name":"senhas","slug":"senhas","term_group":0,"term_taxonomy_id":132,"taxonomy":"post_tag","description":"","parent":0,"count":16,"filter":"raw"},{"term_id":83,"name":"Sgn","slug":"sgn","term_group":0,"term_taxonomy_id":83,"taxonomy":"post_tag","description":"","parent":0,"count":63,"filter":"raw"},{"term_id":104,"name":"Shell","slug":"shell","term_group":0,"term_taxonomy_id":104,"taxonomy":"post_tag","description":"","parent":0,"count":40,"filter":"raw"},{"term_id":105,"name":"Space","slug":"space","term_group":0,"term_taxonomy_id":105,"taxonomy":"post_tag","description":"","parent":0,"count":39,"filter":"raw"},{"term_id":106,"name":"Spc","slug":"spc","term_group":0,"term_taxonomy_id":106,"taxonomy":"post_tag","description":"","parent":0,"count":38,"filter":"raw"},{"term_id":107,"name":"Split","slug":"split","term_group":0,"term_taxonomy_id":107,"taxonomy":"post_tag","description":"","parent":0,"count":37,"filter":"raw"},{"term_id":84,"name":"Sqr","slug":"sqr","term_group":0,"term_taxonomy_id":84,"taxonomy":"post_tag","description":"","parent":0,"count":61,"filter":"raw"},{"term_id":108,"name":"StrComp","slug":"strcomp","term_group":0,"term_taxonomy_id":108,"taxonomy":"post_tag","description":"","parent":0,"count":36,"filter":"raw"},{"term_id":109,"name":"StrConv","slug":"strconv","term_group":0,"term_taxonomy_id":109,"taxonomy":"post_tag","description":"","parent":0,"count":35,"filter":"raw"},{"term_id":110,"name":"String","slug":"string","term_group":0,"term_taxonomy_id":110,"taxonomy":"post_tag","description":"","parent":0,"count":34,"filter":"raw"},{"term_id":111,"name":"StrReverse","slug":"strreverse","term_group":0,"term_taxonomy_id":111,"taxonomy":"post_tag","description":"","parent":0,"count":33,"filter":"raw"},{"term_id":112,"name":"Switch","slug":"switch","term_group":0,"term_taxonomy_id":112,"taxonomy":"post_tag","description":"","parent":0,"count":32,"filter":"raw"},{"term_id":113,"name":"SYD","slug":"syd","term_group":0,"term_taxonomy_id":113,"taxonomy":"post_tag","description":"","parent":0,"count":31,"filter":"raw"},{"term_id":85,"name":"Tan","slug":"tan","term_group":0,"term_taxonomy_id":85,"taxonomy":"post_tag","description":"","parent":0,"count":60,"filter":"raw"},{"term_id":115,"name":"Time","slug":"time","term_group":0,"term_taxonomy_id":115,"taxonomy":"post_tag","description":"","parent":0,"count":30,"filter":"raw"},{"term_id":117,"name":"Timer","slug":"timer","term_group":0,"term_taxonomy_id":117,"taxonomy":"post_tag","description":"","parent":0,"count":29,"filter":"raw"},{"term_id":118,"name":"TimeSerial","slug":"timeserial","term_group":0,"term_taxonomy_id":118,"taxonomy":"post_tag","description":"","parent":0,"count":28,"filter":"raw"},{"term_id":119,"name":"TimeValue","slug":"timevalue","term_group":0,"term_taxonomy_id":119,"taxonomy":"post_tag","description":"","parent":0,"count":27,"filter":"raw"},{"term_id":57,"name":"TIR","slug":"tir","term_group":0,"term_taxonomy_id":57,"taxonomy":"post_tag","description":"","parent":0,"count":89,"filter":"raw"},{"term_id":74,"name":"trim","slug":"trim","term_group":0,"term_taxonomy_id":74,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":120,"name":"TypeName","slug":"typename","term_group":0,"term_taxonomy_id":120,"taxonomy":"post_tag","description":"","parent":0,"count":26,"filter":"raw"},{"term_id":121,"name":"UBound","slug":"ubound","term_group":0,"term_taxonomy_id":121,"taxonomy":"post_tag","description":"","parent":0,"count":25,"filter":"raw"},{"term_id":122,"name":"UCase","slug":"ucase","term_group":0,"term_taxonomy_id":122,"taxonomy":"post_tag","description":"","parent":0,"count":24,"filter":"raw"},{"term_id":28,"name":"Val","slug":"val","term_group":0,"term_taxonomy_id":28,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":123,"name":"VarType","slug":"vartype","term_group":0,"term_taxonomy_id":123,"taxonomy":"post_tag","description":"","parent":0,"count":23,"filter":"raw"},{"term_id":7,"name":"VBA","slug":"vba","term_group":0,"term_taxonomy_id":7,"taxonomy":"post_tag","description":"","parent":0,"count":129,"filter":"raw"},{"term_id":11,"name":"Visual Basic for Applications","slug":"visual-basic-for-applications","term_group":0,"term_taxonomy_id":11,"taxonomy":"post_tag","description":"","parent":0,"count":129,"filter":"raw"},{"term_id":97,"name":"VP","slug":"vp","term_group":0,"term_taxonomy_id":97,"taxonomy":"post_tag","description":"","parent":0,"count":48,"filter":"raw"},{"term_id":94,"name":"VPL","slug":"vpl","term_group":0,"term_taxonomy_id":94,"taxonomy":"post_tag","description":"","parent":0,"count":51,"filter":"raw"},{"term_id":124,"name":"Weekday","slug":"weekday","term_group":0,"term_taxonomy_id":124,"taxonomy":"post_tag","description":"","parent":0,"count":22,"filter":"raw"},{"term_id":126,"name":"WeekdayName","slug":"weekdayname","term_group":0,"term_taxonomy_id":126,"taxonomy":"post_tag","description":"","parent":0,"count":21,"filter":"raw"},{"term_id":127,"name":"Year","slug":"year","term_group":0,"term_taxonomy_id":127,"taxonomy":"post_tag","description":"","parent":0,"count":17,"filter":"raw"}],"post_format":false},"author_name":"admin","author_url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/","author_email":"admin@saibam.com.br","author_website":"https:\/\/saibam.com.br\/excel","author_description":"","author_facebook":"","author_twitter":"","author_instagram":"","author_role":["administrator"],"author_firstname":"","author_lastname":"","user_login":"Pizza","author_avatar":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=200&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=400&#038;d=mm&#038;r=g 2x' class='avatar avatar-200 photo' height='200' width='200' decoding='async'\/>","author_avatar_url":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","comment_count":0,"post_likes":0,"post_views":0},"tpgb_post_category":{"category":"<a href=\"https:\/\/saibam.com.br\/excel\/category\/funcoes-ninjas\/\" alt=\"Fun\u00e7\u00f5es Ninjas\" class=\"category-funcoes-ninjas\">Fun\u00e7\u00f5es Ninjas<\/a> ","post_tag":"<a href=\"https:\/\/saibam.com.br\/excel\/tag\/abs\/\" alt=\"Abs\" class=\"post_tag-abs\">Abs<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/atn\/\" alt=\"Atn\" class=\"post_tag-atn\">Atn<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/base64-decode\/\" alt=\"Base64 Decode\" class=\"post_tag-base64-decode\">Base64 Decode<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/base64-encode\/\" alt=\"Base64 Encode\" class=\"post_tag-base64-encode\">Base64 Encode<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/cep\/\" alt=\"cep\" class=\"post_tag-cep\">cep<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/cnh\/\" alt=\"cnh\" class=\"post_tag-cnh\">cnh<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/cnpj\/\" alt=\"cnpj\" class=\"post_tag-cnpj\">cnpj<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/conversao-de-texto-para-numero\/\" alt=\"Convers\u00e3o de Texto para N\u00famero\" class=\"post_tag-conversao-de-texto-para-numero\">Convers\u00e3o de Texto para N\u00famero<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/cos\/\" alt=\"Cos\" class=\"post_tag-cos\">Cos<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/cpf\/\" alt=\"cpf\" class=\"post_tag-cpf\">cpf<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/curdir\/\" alt=\"CurDir\" class=\"post_tag-curdir\">CurDir<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/data\/\" alt=\"data\" class=\"post_tag-data\">data<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/dateadd\/\" alt=\"dateadd\" class=\"post_tag-dateadd\">dateadd<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/datediff\/\" alt=\"datediff\" class=\"post_tag-datediff\">datediff<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/datepart\/\" alt=\"DatePart\" class=\"post_tag-datepart\">DatePart<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/dateserial\/\" alt=\"dateserial\" class=\"post_tag-dateserial\">dateserial<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/day\/\" alt=\"day\" class=\"post_tag-day\">day<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/doevents\/\" alt=\"doevents\" class=\"post_tag-doevents\">doevents<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/eof\/\" alt=\"EOF\" class=\"post_tag-eof\">EOF<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/epoch-time\/\" alt=\"Epoch Time\" class=\"post_tag-epoch-time\">Epoch Time<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/error\/\" alt=\"error\" class=\"post_tag-error\">error<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/exp\/\" alt=\"Exp\" class=\"post_tag-exp\">Exp<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/fileattr\/\" alt=\"FileAttr\" class=\"post_tag-fileattr\">FileAttr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/filedatetime\/\" alt=\"FileDateTime\" class=\"post_tag-filedatetime\">FileDateTime<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/filelen\/\" alt=\"FileLen\" class=\"post_tag-filelen\">FileLen<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/freefile\/\" alt=\"freefile\" class=\"post_tag-freefile\">freefile<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/funcao-day\/\" alt=\"fun\u00e7\u00e3o day\" class=\"post_tag-funcao-day\">fun\u00e7\u00e3o day<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/funcao-val\/\" alt=\"Fun\u00e7\u00e3o Val\" class=\"post_tag-funcao-val\">Fun\u00e7\u00e3o Val<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/getattr\/\" alt=\"GetAttr\" class=\"post_tag-getattr\">GetAttr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/getobject\/\" alt=\"GetObject\" class=\"post_tag-getobject\">GetObject<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/getsetting\/\" alt=\"GetSetting\" class=\"post_tag-getsetting\">GetSetting<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/hora\/\" alt=\"hora\" class=\"post_tag-hora\">hora<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ie\/\" alt=\"IE\" class=\"post_tag-ie\">IE<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/iif\/\" alt=\"iif\" class=\"post_tag-iif\">iif<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/input\/\" alt=\"Input\" class=\"post_tag-input\">Input<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/inputbox\/\" alt=\"InputBox\" class=\"post_tag-inputbox\">InputBox<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/instr\/\" alt=\"InStr\" class=\"post_tag-instr\">InStr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/instrrev\/\" alt=\"InStrRev\" class=\"post_tag-instrrev\">InStrRev<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/int\/\" alt=\"Int\" class=\"post_tag-int\">Int<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ip\/\" alt=\"IP\" class=\"post_tag-ip\">IP<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ipmt\/\" alt=\"IPmt\" class=\"post_tag-ipmt\">IPmt<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isarray\/\" alt=\"IsArray\" class=\"post_tag-isarray\">IsArray<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isdate\/\" alt=\"IsDate\" class=\"post_tag-isdate\">IsDate<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isempty\/\" alt=\"IsEmpty\" class=\"post_tag-isempty\">IsEmpty<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ismissing\/\" alt=\"IsMissing\" class=\"post_tag-ismissing\">IsMissing<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isnull\/\" alt=\"IsNull\" class=\"post_tag-isnull\">IsNull<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isobject\/\" alt=\"IsObject\" class=\"post_tag-isobject\">IsObject<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/join\/\" alt=\"Join\" class=\"post_tag-join\">Join<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/lbound\/\" alt=\"LBound\" class=\"post_tag-lbound\">LBound<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/lcase\/\" alt=\"LCase\" class=\"post_tag-lcase\">LCase<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/left\/\" alt=\"Left\" class=\"post_tag-left\">Left<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/loc\/\" alt=\"LOC\" class=\"post_tag-loc\">LOC<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/lof\/\" alt=\"LOF\" class=\"post_tag-lof\">LOF<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/log\/\" alt=\"Log\" class=\"post_tag-log\">Log<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ltrim\/\" alt=\"LTrim\" class=\"post_tag-ltrim\">LTrim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/mega-sena\/\" alt=\"mega sena\" class=\"post_tag-mega-sena\">mega sena<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/mid\/\" alt=\"MID\" class=\"post_tag-mid\">MID<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/minute\/\" alt=\"Minute\" class=\"post_tag-minute\">Minute<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/month\/\" alt=\"Month\" class=\"post_tag-month\">Month<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/monthname\/\" alt=\"MonthName\" class=\"post_tag-monthname\">MonthName<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/msgbox\/\" alt=\"MsgBox\" class=\"post_tag-msgbox\">MsgBox<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/nomes\/\" alt=\"nomes\" class=\"post_tag-nomes\">nomes<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/now\/\" alt=\"Now\" class=\"post_tag-now\">Now<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/nper\/\" alt=\"NPer\" class=\"post_tag-nper\">NPer<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/numeros-por-extenso\/\" alt=\"n\u00fameros por extenso\" class=\"post_tag-numeros-por-extenso\">n\u00fameros por extenso<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/pmt\/\" alt=\"Pmt\" class=\"post_tag-pmt\">Pmt<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ppmt\/\" alt=\"PPmt\" class=\"post_tag-ppmt\">PPmt<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/qbcolor\/\" alt=\"QBColor\" class=\"post_tag-qbcolor\">QBColor<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/rg\/\" alt=\"rg\" class=\"post_tag-rg\">rg<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/right\/\" alt=\"Right\" class=\"post_tag-right\">Right<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/rnd\/\" alt=\"Rnd\" class=\"post_tag-rnd\">Rnd<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/round\/\" alt=\"Round\" class=\"post_tag-round\">Round<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/rtrim\/\" alt=\"rtrim\" class=\"post_tag-rtrim\">rtrim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/rtrim-e-trim\/\" alt=\"RTrim e Trim\" class=\"post_tag-rtrim-e-trim\">RTrim e Trim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/second\/\" alt=\"Second\" class=\"post_tag-second\">Second<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/seek\/\" alt=\"Seek\" class=\"post_tag-seek\">Seek<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/senhas\/\" alt=\"senhas\" class=\"post_tag-senhas\">senhas<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/sgn\/\" alt=\"Sgn\" class=\"post_tag-sgn\">Sgn<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/shell\/\" alt=\"Shell\" class=\"post_tag-shell\">Shell<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/space\/\" alt=\"Space\" class=\"post_tag-space\">Space<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/spc\/\" alt=\"Spc\" class=\"post_tag-spc\">Spc<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/split\/\" alt=\"Split\" class=\"post_tag-split\">Split<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/sqr\/\" alt=\"Sqr\" class=\"post_tag-sqr\">Sqr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/strcomp\/\" alt=\"StrComp\" class=\"post_tag-strcomp\">StrComp<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/strconv\/\" alt=\"StrConv\" class=\"post_tag-strconv\">StrConv<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/string\/\" alt=\"String\" class=\"post_tag-string\">String<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/strreverse\/\" alt=\"StrReverse\" class=\"post_tag-strreverse\">StrReverse<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/switch\/\" alt=\"Switch\" class=\"post_tag-switch\">Switch<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/syd\/\" alt=\"SYD\" class=\"post_tag-syd\">SYD<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/tan\/\" alt=\"Tan\" class=\"post_tag-tan\">Tan<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/time\/\" alt=\"Time\" class=\"post_tag-time\">Time<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/timer\/\" alt=\"Timer\" class=\"post_tag-timer\">Timer<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/timeserial\/\" alt=\"TimeSerial\" class=\"post_tag-timeserial\">TimeSerial<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/timevalue\/\" alt=\"TimeValue\" class=\"post_tag-timevalue\">TimeValue<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/tir\/\" alt=\"TIR\" class=\"post_tag-tir\">TIR<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/trim\/\" alt=\"trim\" class=\"post_tag-trim\">trim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/typename\/\" alt=\"TypeName\" class=\"post_tag-typename\">TypeName<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ubound\/\" alt=\"UBound\" class=\"post_tag-ubound\">UBound<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ucase\/\" alt=\"UCase\" class=\"post_tag-ucase\">UCase<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/val\/\" alt=\"Val\" class=\"post_tag-val\">Val<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/vartype\/\" alt=\"VarType\" class=\"post_tag-vartype\">VarType<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/vba\/\" alt=\"VBA\" class=\"post_tag-vba\">VBA<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/visual-basic-for-applications\/\" alt=\"Visual Basic for Applications\" class=\"post_tag-visual-basic-for-applications\">Visual Basic for Applications<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/vp\/\" alt=\"VP\" class=\"post_tag-vp\">VP<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/vpl\/\" alt=\"VPL\" class=\"post_tag-vpl\">VPL<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/weekday\/\" alt=\"Weekday\" class=\"post_tag-weekday\">Weekday<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/weekdayname\/\" alt=\"WeekdayName\" class=\"post_tag-weekdayname\">WeekdayName<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/year\/\" alt=\"Year\" class=\"post_tag-year\">Year<\/a> "},"_links":{"self":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/1483","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/comments?post=1483"}],"version-history":[{"count":13,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/1483\/revisions"}],"predecessor-version":[{"id":1651,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/1483\/revisions\/1651"}],"wp:attachment":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/media?parent=1483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/categories?post=1483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/tags?post=1483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}