<br />
<b>Notice</b>:  Function _load_textdomain_just_in_time was called <strong>incorrectly</strong>. Translation loading for the <code>breadcrumb-navxt</code> domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the <code>init</code> action or later. Please see <a href="https://developer.wordpress.org/advanced-administration/debug/debug-wordpress/">Debugging in WordPress</a> for more information. (This message was added in version 6.7.0.) in <b>/home/devtools/public_html/blog/wp-includes/functions.php</b> on line <b>6131</b><br />
{"id":1075,"date":"2021-07-19T08:00:00","date_gmt":"2021-07-19T11:00:00","guid":{"rendered":"https:\/\/devtools.com.br\/blog\/?p=1075"},"modified":"2022-08-01T19:55:40","modified_gmt":"2022-08-01T22:55:40","slug":"como-formatar-celulas-no-excel","status":"publish","type":"post","link":"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/","title":{"rendered":"Como formatar c\u00e9lulas no Excel"},"content":{"rendered":"\n<p>Para quem utiliza o Excel com frequ\u00eancia, \u00e9 comum ter d\u00favidas sobre como formatar c\u00e9lulas, ent\u00e3o neste post iremos abordar como voc\u00ea pode aplicar diversos tipos de formata\u00e7\u00e3o nas c\u00e9lulas do seu Excel.<\/p>\n\n\n\n<p>Veja abaixo quais os tipos de formata\u00e7\u00e3o de c\u00e9culas que vamos abordar.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"#moeda_excel\">Como formatar moeda no Excel (Reais, Dolar);<\/a><\/li><li><a href=\"#cpf\">Como formatar CPF no Excel;<\/a><\/li><li><a href=\"#cnpj\">Como formatar CNPJ no Excel;<\/a><\/li><li><a href=\"#numeros\">Como formatar n\u00fameros no Excel;<\/a><\/li><li><a href=\"#datas\">Como formatar datas no Excel;<\/a><\/li><li><a href=\"#horas\">Como formatar horas no Excel;<\/a><\/li><li><a href=\"#cep\">Como formatar CEP no Excel<\/a>.<\/li><\/ul>\n\n\n\n<p>Todas as a\u00e7\u00f5es necess\u00e1rias para formata\u00e7\u00e3o e configura\u00e7\u00e3o de c\u00e9lulas no Excel \u00e9 feita atrav\u00e9s da op\u00e7\u00e3o Formatar C\u00e9lulas, dispon\u00edvel quando voc\u00ea clica com o bot\u00e3o direiro do mouse ou quando aciona <a href=\"https:\/\/devtools.com.br\/dicas\/teclas-de-atalho-no-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">teclas de atalho<\/a>, como CTRL + 1.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"moeda_excel\"><strong>Como formatar moeda no Excel (Reais, Dolar)<\/strong><\/h2>\n\n\n\n<p>Para formatar suas c\u00e9lulas no formato moeda, utilize a op\u00e7\u00e3o e mesmo nome:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"700\" height=\"628\" src=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-moeda-no-excel.png\" alt=\"Imagem demonstrando como formatar dados do tipo moeda no Excel.\" class=\"wp-image-1129\" title=\"Formatando Moedas no Excel\" srcset=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-moeda-no-excel.png 700w, https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-moeda-no-excel-300x269.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<p>Nesta op\u00e7\u00e3o voc\u00ea pode formatar a quantidade de casas decimais, o s\u00edmbolo, no caso, Reais, Dolar, Euro, Libra, at\u00e9 Bitcoin. Ainda \u00e9 poss\u00edvel determinar o formato dos valores negativos.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"cpf\"><strong>Como formatar CPF no Excel<\/strong><\/h2>\n\n\n\n<p><\/p>\n\n\n\n<div id=\"denakop-ad-horizontal-1\">\n   <script type=\"text\/javascript\">\n     denakop.cmd.push(function () {\n        denakop.displayAd({\n           divId: \"denakop-ad-horizontal-1\",\n           name: \"horizontal\",\n           refresh: 30,\n        });\n     });\n   <\/script>\n<\/div>\n\n\n\n<p><\/p>\n\n\n\n<p>O CPF \u00e9 um documento brasileiro, por isto, o Excel acaba n\u00e3o tendo uma op\u00e7\u00e3o para formatar tal n\u00famera\u00e7\u00e3o, ele at\u00e9 tem, mas n\u00e3o aplica a forma\u00e7\u00e3o com a pontua\u00e7\u00e3o.<\/p>\n\n\n\n<p>A op\u00e7\u00e3o nativa de forma\u00e7\u00e3o do CPF no Excel fica na categoria Especial, tipo CIC, mas como apontei acima, o formato trazido fica 123456789-00, agora, para formatar com os pontos e tra\u00e7os, precisaremos utilizar a categoria Personalizado.<\/p>\n\n\n\n<p>Ao acionar a op\u00e7\u00e3o Personalizado voc\u00ea poder\u00e1 determinar o formato, no caso, iremos apontar que o tipo para o CPF ser\u00e1 <strong>0##&#8221;.&#8221;###&#8221;.&#8221;###-##<\/strong>, veja no exemplo como ficou:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"696\" height=\"632\" src=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-cpf-no-excel.png\" alt=\"Imagem da tela de formata\u00e7\u00e3o de c\u00e9lulas do Microsoft Excel\" class=\"wp-image-1131\" title=\"Como formatar CPF no Excel\" srcset=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-cpf-no-excel.png 696w, https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-cpf-no-excel-300x272.png 300w\" sizes=\"(max-width: 696px) 100vw, 696px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"cnpj\"><strong>Como formatar CNPJ no Excel<\/strong><\/h2>\n\n\n\n<p>A formata\u00e7\u00e3o de CNPJ no Excel \u00e9 feita no mesmo caminho onde formatamos o CPF, a diferen\u00e7a est\u00e1 no formato, que \u00e9: <strong>##&#8221;.&#8221;###&#8221;.&#8221;###&#8221;\/&#8221;####-##<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"695\" height=\"633\" src=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-cnpj-no-excel.png\" alt=\"Formata\u00e7\u00e3o de c\u00e9lula no Excel para apresentar o CNPJ formatado.\" class=\"wp-image-1134\" title=\"Como formatar CNPJ no Excel\" srcset=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-cnpj-no-excel.png 695w, https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-cnpj-no-excel-300x273.png 300w\" sizes=\"(max-width: 695px) 100vw, 695px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"numeros\"><strong>Como formatar n\u00fameros no Excel<\/strong><\/h2>\n\n\n\n<p>Na formata\u00e7\u00e3o de n\u00fameros do Excel voc\u00ea pode ter:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Apresentar casas decimais ou n\u00e3o, inclusive a quantidade;<\/li><li>Se deseja utilizar separador de milhar;<\/li><li>E como deseja apresentar os valores negativos, com ou sem o sinal de menos, na cor vermelha.<\/li><\/ul>\n\n\n\n<p>Lembrando que ao aplicar formata\u00e7\u00e3o com duas casas decimais, o Excel ir\u00e1 realizar automaticamente o arredondamento.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"700\" height=\"628\" src=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/formatando-numeros-no-excel.png\" alt=\"Op\u00e7\u00e3o de formata\u00e7\u00e3o de c\u00e9lula no Excel para apresenta\u00e7\u00e3o de n\u00fameros.\" class=\"wp-image-1126\" title=\"Formatando N\u00fameros no Excel\" srcset=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/formatando-numeros-no-excel.png 700w, https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/formatando-numeros-no-excel-300x269.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"datas\"><strong>Como formatar datas no Excel<\/strong><\/h2>\n\n\n\n<p>O Excel por padr\u00e3o j\u00e1 interpreta e formata datas, as vezes o formato acaba n\u00e3o sendo o desejado, ent\u00e3o, se faz necess\u00e1rio aplicar forma\u00e7\u00e3o, veja as op\u00e7\u00f5es que se podem aplicar.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"698\" height=\"630\" src=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-data-no-excel-min.png\" alt=\"Explica\u00e7\u00e3o de formato de c\u00e9lula com informa\u00e7\u00f5es de data.\" class=\"wp-image-1137\" title=\"Como formatar data no Excel\" srcset=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-data-no-excel-min.png 698w, https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-data-no-excel-min-300x271.png 300w\" sizes=\"(max-width: 698px) 100vw, 698px\" \/><\/figure>\n\n\n\n<p>Veja que \u00e9 poss\u00edvel formatar a quantidade de caracteres para o m\u00eas, o ano, colocar a data por extenso, e at\u00e9 indicar a localidade a qual a data se refere, aplicando assim o formato daquele local.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"horas\"><strong>Como formatar horas no Excel<\/strong><\/h2>\n\n\n\n<p>Assim como a data, o Excel tamb\u00e9m j\u00e1 formata automaticamente valores do tipo hora, e tamb\u00e9m \u00e9 poss\u00edvel personalizar, por exemplo, mostrar hora:minuto, ou hora:minuto:segundo, hora no formato AM\/PM, s\u00f3 minutos, s\u00f3 segundos, enfim, a quantidade de possibilidades \u00e9 enorme, basta ir alterando as op\u00e7\u00f5es nativas que o Excel j\u00e1 lhe ofere.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"696\" height=\"631\" src=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-hora-no-excel-min-min.png\" alt=\"Ilustra\u00e7\u00e3o de como formatar horas no Excel.\" class=\"wp-image-1139\" title=\"Como formatar horas no Excel\" srcset=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-hora-no-excel-min-min.png 696w, https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-hora-no-excel-min-min-300x272.png 300w\" sizes=\"(max-width: 696px) 100vw, 696px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"cep\"><strong>Como formatar CEP no Excel<\/strong><\/h2>\n\n\n\n<p>A formata\u00e7\u00e3o do CEP pode ser realizada utilizando a op\u00e7\u00e3o nativa do Excel, que fica na categoria Especial, ou voc\u00ea pode definir a sua formata\u00e7\u00e3o, pois, a padr\u00e3o n\u00e3o faz a separa\u00e7\u00e3o por ponto, apenas por tra\u00e7o. Ent\u00e3o a formata\u00e7\u00e3o especial ficar\u00e1 <strong>##&#8221;.&#8221;###&#8221;-&#8220;###<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"696\" height=\"631\" src=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-cep-no-excel-min.png\" alt=\"F\u00f3rmula personalizada para formata\u00e7\u00e3o de CEP no Excel\" class=\"wp-image-1141\" title=\"Como formatar CEP no Excel\" srcset=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-cep-no-excel-min.png 696w, https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/como-formatar-cep-no-excel-min-300x272.png 300w\" sizes=\"(max-width: 696px) 100vw, 696px\" \/><\/figure>\n\n\n\n<p>Dentro da formata\u00e7\u00e3o de c\u00e9lulas como voc\u00ea observou nas imagens acima \u00e9 poss\u00edvel contar com diversos tipos de formatos, como:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Geral;<\/li><li>N\u00famero;<\/li><li>Moeda;<\/li><li>Cont\u00e1bil;<\/li><li>Data;<\/li><li>Hora;<\/li><li>Porcentagem;<\/li><li>Fra\u00e7\u00e3o;<\/li><li>Cient\u00edfico;<\/li><li>Texto;<\/li><li>Especial;<\/li><li>Personalizado.<\/li><\/ul>\n\n\n\n<p>Caso voc\u00ea precise entender como formatar c\u00e9lulas no Excel para um formato diferente dos apresentados, voc\u00ea poder\u00e1 criar o seu atrav\u00e9s da categoria Personalizado, assim como fizemos nos casos de CPF, CNPJ e CEP.<\/p>\n\n\n\n<p>Agora, ficou na d\u00favida em como fazer a forma\u00e7\u00e3o de algum outro tipo de registro, coloca nos coment\u00e1rios que buscaremos lhe auxiliar.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Para quem utiliza o Excel com frequ\u00eancia, \u00e9 comum ter d\u00favidas sobre como formatar c\u00e9lulas, ent\u00e3o neste post iremos abordar como voc\u00ea pode aplicar diversos tipos de formata\u00e7\u00e3o nas c\u00e9lulas do seu Excel. Veja abaixo quais os tipos de formata\u00e7\u00e3o de c\u00e9culas que vamos abordar. Como formatar moeda no Excel (Reais, Dolar); Como formatar CPF &#8230; <a title=\"Como formatar c\u00e9lulas no Excel\" class=\"read-more\" href=\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/\" aria-label=\"More on Como formatar c\u00e9lulas no Excel\">Ler mais<\/a><\/p>\n","protected":false},"author":1,"featured_media":1147,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[244],"tags":[],"class_list":["post-1075","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como formatar c\u00e9lulas no Excel<\/title>\n<meta name=\"description\" content=\"Aprenda como formatar as c\u00e9lulas do seu Excel, formate datas, moedas, cpf, cnpj, datas, horas, simples e r\u00e1pido.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como formatar c\u00e9lulas no Excel\" \/>\n<meta property=\"og:description\" content=\"Aprenda como formatar as c\u00e9lulas do seu Excel, formate datas, moedas, cpf, cnpj, datas, horas, simples e r\u00e1pido.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Devtools\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-19T11:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-01T22:55:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/Como-Formatar-Celulas-no-Excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"675\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Fabiano Abreu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fabiano Abreu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/\"},\"author\":{\"name\":\"Fabiano Abreu\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"headline\":\"Como formatar c\u00e9lulas no Excel\",\"datePublished\":\"2021-07-19T11:00:00+00:00\",\"dateModified\":\"2022-08-01T22:55:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/\"},\"wordCount\":696,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"image\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/Como-Formatar-Celulas-no-Excel.png\",\"articleSection\":[\"Excel\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/\",\"url\":\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/\",\"name\":\"Como formatar c\u00e9lulas no Excel\",\"isPartOf\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/Como-Formatar-Celulas-no-Excel.png\",\"datePublished\":\"2021-07-19T11:00:00+00:00\",\"dateModified\":\"2022-08-01T22:55:40+00:00\",\"description\":\"Aprenda como formatar as c\u00e9lulas do seu Excel, formate datas, moedas, cpf, cnpj, datas, horas, simples e r\u00e1pido.\",\"breadcrumb\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#primaryimage\",\"url\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/Como-Formatar-Celulas-no-Excel.png\",\"contentUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/Como-Formatar-Celulas-no-Excel.png\",\"width\":1200,\"height\":675,\"caption\":\"Foto de um computador com uma planilha do Excel aberta\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/devtools.com.br\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como formatar c\u00e9lulas no Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#website\",\"url\":\"https:\/\/devtools.com.br\/blog\/\",\"name\":\"Devtools\",\"description\":\"Sua caixa de ferramentas online\",\"publisher\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/devtools.com.br\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\",\"name\":\"Fabiano Abreu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png\",\"contentUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png\",\"width\":184,\"height\":184,\"caption\":\"Fabiano Abreu\"},\"logo\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/devtools.com.br\/blog\"],\"url\":\"https:\/\/devtools.com.br\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como formatar c\u00e9lulas no Excel","description":"Aprenda como formatar as c\u00e9lulas do seu Excel, formate datas, moedas, cpf, cnpj, datas, horas, simples e r\u00e1pido.","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:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/","og_locale":"pt_BR","og_type":"article","og_title":"Como formatar c\u00e9lulas no Excel","og_description":"Aprenda como formatar as c\u00e9lulas do seu Excel, formate datas, moedas, cpf, cnpj, datas, horas, simples e r\u00e1pido.","og_url":"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/","og_site_name":"Devtools","article_published_time":"2021-07-19T11:00:00+00:00","article_modified_time":"2022-08-01T22:55:40+00:00","og_image":[{"width":1200,"height":675,"url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/Como-Formatar-Celulas-no-Excel.png","type":"image\/png"}],"author":"Fabiano Abreu","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Fabiano Abreu","Est. tempo de leitura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#article","isPartOf":{"@id":"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/"},"author":{"name":"Fabiano Abreu","@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"headline":"Como formatar c\u00e9lulas no Excel","datePublished":"2021-07-19T11:00:00+00:00","dateModified":"2022-08-01T22:55:40+00:00","mainEntityOfPage":{"@id":"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/"},"wordCount":696,"commentCount":0,"publisher":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"image":{"@id":"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/Como-Formatar-Celulas-no-Excel.png","articleSection":["Excel"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/","url":"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/","name":"Como formatar c\u00e9lulas no Excel","isPartOf":{"@id":"https:\/\/devtools.com.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#primaryimage"},"image":{"@id":"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/Como-Formatar-Celulas-no-Excel.png","datePublished":"2021-07-19T11:00:00+00:00","dateModified":"2022-08-01T22:55:40+00:00","description":"Aprenda como formatar as c\u00e9lulas do seu Excel, formate datas, moedas, cpf, cnpj, datas, horas, simples e r\u00e1pido.","breadcrumb":{"@id":"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#primaryimage","url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/Como-Formatar-Celulas-no-Excel.png","contentUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/07\/Como-Formatar-Celulas-no-Excel.png","width":1200,"height":675,"caption":"Foto de um computador com uma planilha do Excel aberta"},{"@type":"BreadcrumbList","@id":"https:\/\/devtools.com.br\/blog\/como-formatar-celulas-no-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/devtools.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Como formatar c\u00e9lulas no Excel"}]},{"@type":"WebSite","@id":"https:\/\/devtools.com.br\/blog\/#website","url":"https:\/\/devtools.com.br\/blog\/","name":"Devtools","description":"Sua caixa de ferramentas online","publisher":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devtools.com.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":["Person","Organization"],"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed","name":"Fabiano Abreu","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/","url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png","contentUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png","width":184,"height":184,"caption":"Fabiano Abreu"},"logo":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/devtools.com.br\/blog"],"url":"https:\/\/devtools.com.br\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/1075","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/comments?post=1075"}],"version-history":[{"count":19,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/1075\/revisions"}],"predecessor-version":[{"id":1612,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/1075\/revisions\/1612"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/media\/1147"}],"wp:attachment":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/media?parent=1075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/categories?post=1075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/tags?post=1075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}