{"id":2242,"date":"2020-11-25T10:39:37","date_gmt":"2020-11-25T10:39:37","guid":{"rendered":"http:\/\/pt.repairmsexcel.com\/blog\/?p=2242"},"modified":"2021-07-23T12:06:24","modified_gmt":"2021-07-23T12:06:24","slug":"excel-nao-reconhece-formato-data","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data","title":{"rendered":"8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel"},"content":{"rendered":"<div class=\"cb46ff181ce6eef70c33ac8d8c9c88c4\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">Todo o seu trabalho \u00e1rduo de manter os dados com a data adequada parece ter sido perdido porque, de repente, o\u00a0<strong>Excel n\u00e3o reconhece formato data?<\/strong><\/p>\n<p style=\"text-align: justify;\">Esta situa\u00e7\u00e3o problem\u00e1tica pode acontecer a qualquer hora e com qualquer pessoa, ent\u00e3o todos voc\u00eas precisam estar preparados para corrigir esse\u00a0<strong>formato de data do Excel\u00a0<\/strong>bagun\u00e7a de forma inteligente.<!--more--><\/p>\n<p style=\"text-align: justify;\">Se voc\u00ea n\u00e3o tem ideia de\u00a0<strong>como consertar Excel por n\u00e3o reconhecer <\/strong><strong>formato data problemas<\/strong>, tamb\u00e9m n\u00e3o precisa se preocupar.\u00a0Como no t\u00f3pico do nosso blog de hoje, discutiremos esse espec\u00edfico\u00a0<strong>formato de data <\/strong><strong>que n\u00e3o muda no <\/strong>\u00a0<strong>Excel <\/strong>problema do e as maneiras de corrigir isso.<\/p>\n<h2 style=\"text-align: justify;\"><strong><u>Quando Excel n\u00e3o reconhece formato data?<\/u><\/strong><\/h2>\n<ul style=\"text-align: justify;\">\n<li>Quando voc\u00ea copia ou importa dados para o Excel e todos os seus formatos de data d\u00e3o errado.<\/li>\n<li>O Excel reconhece as datas erradas e todos os dias e meses s\u00e3o trocados.<\/li>\n<li>Ao trabalhar com o arquivo Excel que \u00e9 exportado atrav\u00e9s do relat\u00f3rio.\u00a0Voc\u00ea pode descobrir que, ap\u00f3s alterar o formato da c\u00e9lula do valor da data para uma data, est\u00e1 retornando os dados errados.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><strong><u>Por que o Excel n\u00e3o reconhece formato data?<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">Seu sistema est\u00e1 reconhecendo datas no\u00a0formato\u00a0dd\u00a0\/ mm \/\u00a0aa\u00a0.\u00a0Ao passo que, em seu arquivo de origem ou de onde voc\u00ea est\u00e1 copiando \/ importando os dados, ele segue o\u00a0formato de data\u00a0mm \/\u00a0dd\u00a0\/\u00a0aa\u00a0.<\/p>\n<p style=\"text-align: justify;\">A segunda possibilidade \u00e9 que, ao tentar classificar essa coluna de datas, todos os dados sejam organizados na ordem incorreta.<\/p>\n<h2 style=\"text-align: justify;\"><strong><u>Como Para Fix Excel n\u00e3o reconhecer Formato data?<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">Resolver a\u00a0<strong>data sem alterar<\/strong>\u00a0<strong>Excel <\/strong>problema do n\u00e3o \u00e9 uma tarefa dif\u00edcil, mas para isso, voc\u00ea precisa saber a solu\u00e7\u00e3o certa.<\/p>\n<p style=\"text-align: justify;\">Aqui est\u00e3o as corre\u00e7\u00f5es que voc\u00ea precisa aplicar para corrigir esse problema de o\u00a0<strong>Excel n\u00e3o reconhecer formato\u00a0 data.<\/strong><\/p>\n<h3 style=\"text-align: justify;\"><strong><u>1 # Texto\u00a0para\u00a0colunas<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Aqui est\u00e3o as corre\u00e7\u00f5es que voc\u00ea precisa executar.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Em primeiro lugar, voc\u00ea precisa destacar as c\u00e9lulas com as datas.\u00a0Se desejar, selecione a coluna completa.<\/li>\n<li>Agora, na faixa do Excel, toque no\u00a0menu\u00a0Dados\u00a0e escolha a op\u00e7\u00e3o\u00a0&#8216;Texto para colunas&#8217;\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2246\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-1.png\" alt=\"Texto\u00a0para\u00a0colunas 1\" width=\"365\" height=\"349\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-1.png 365w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-1-300x287.png 300w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Na caixa de di\u00e1logo aberta, escolha a op\u00e7\u00e3o\u00a0&#8216;Largura fixa&#8217;\u00a0e clique no\u00a0bot\u00e3o\u00a0Avan\u00e7ar\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2247\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-2.png\" alt=\"Texto\u00a0para\u00a0colunas 2\" width=\"524\" height=\"400\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-2.png 524w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-2-300x229.png 300w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Se houver linhas verticais com setas presentes, que s\u00e3o chamadas de\u00a0linhas de\u00a0quebra de coluna\u00a0.\u00a0Em seguida, v\u00e1 imediatamente at\u00e9 a se\u00e7\u00e3o de dados e clique duas vezes neles para remover todos eles.\u00a0Depois disso, clique no\u00a0bot\u00e3o\u00a0Avan\u00e7ar\u00a0.<\/li>\n<li>Agora, nas\u00a0se\u00e7\u00f5es\u00a0&#8216;Formato de dados da coluna&#8217;,\u00a0acesse a lista suspensa de datas e escolha o MDY ou qualquer formato de data que deseja aplicar.<\/li>\n<li>Clique no\u00a0bot\u00e3o\u00a0Concluir\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2248\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-3.jpg\" alt=\"Texto\u00a0para\u00a0colunas 3\" width=\"512\" height=\"415\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-3.jpg 512w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-3-300x243.jpg 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/p>\n<p style=\"text-align: justify;\">Muito em breve, o seu Excel ir\u00e1 ler todas as datas MDY importadas e depois ir\u00e1 convert\u00ea-las para o formato DMY.\u00a0Todo o seu problema de\u00a0<strong>Excel n\u00e3o reconhecer formato data <\/strong>foi corrigido em apenas alguns segundos.<\/p>\n<h3 style=\"text-align: justify;\"><strong><u>2 # Datas como texto<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Na figura mostrada, voc\u00ea pode ver que h\u00e1 uma\u00a0coluna de\u00a0datas\u00a0importadas\u00a0na qual os dados e a hora s\u00e3o exibidos.\u00a0Caso n\u00e3o queira mostrar a hora e para isso, definiu o formato da coluna como Data Abreviada.\u00a0Mas nada\u00a0aconteceu que o\u00a0<strong>formato da data n\u00e3o mudou no Excel.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2249\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-4.png\" alt=\"Datas como texto\" width=\"402\" height=\"300\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-4.png 402w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-4-300x224.png 300w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/p>\n<p style=\"text-align: justify;\">Agora surge a pergunta:\u00a0<strong>por que formato de data do Excel n\u00e3o est\u00e1 mudando?<\/strong><\/p>\n<p style=\"text-align: justify;\">\u00a0Isso ocorre principalmente porque o Excel est\u00e1 considerando essas datas como texto.\u00a0No entanto, o Excel n\u00e3o aplicar\u00e1 formata\u00e7\u00e3o de n\u00famero no texto.<\/p>\n<p style=\"text-align: justify;\">Se tiver d\u00favidas se o conte\u00fado da c\u00e9lula de data tamb\u00e9m \u00e9 contado como texto, verifique estes sinais para esclarecer suas d\u00favidas.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Se for contado como texto, as datas aparecer\u00e3o alinhadas \u00e0 esquerda.<\/li>\n<li>Voc\u00ea ver\u00e1 um ap\u00f3strofo bem no in\u00edcio da data.<\/li>\n<li>Quando voc\u00ea seleciona mais de uma data, o\u00a0Quick Calc\u00a0que est\u00e1 presente na\u00a0Barra de Status\u00a0mostrar\u00e1 apenas a Contagem, n\u00e3o a soma Num\u00e9rica ou Contagem.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2250\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-5.png\" alt=\"Datas como texto 1\" width=\"348\" height=\"302\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-5.png 348w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-5-300x260.png 300w\" sizes=\"auto, (max-width: 348px) 100vw, 348px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><strong><u>3 # Converter data\u00a0em\u00a0n\u00fameros<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Depois de identificar que sua data \u00e9 um formato de texto, \u00e9 hora de mudar a data para n\u00fameros para resolver o problema.\u00a0\u00c9 assim que o Excel armazenar\u00e1 apenas as datas v\u00e1lidas.<\/p>\n<p style=\"text-align: justify;\">Para tal, a melhor solu\u00e7\u00e3o \u00e9 usar o recurso Texto para Colunas do Excel.\u00a0Aqui est\u00e1 como deve ser usado.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Escolha primeiro as c\u00e9lulas nas quais suas datas est\u00e3o presentes.<\/li>\n<li>Na faixa do Excel, toque em\u00a0Dados.<\/li>\n<li>Clique na\u00a0op\u00e7\u00e3o Texto para colunas.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2251\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-6.png\" alt=\"Converter data\u00a0em\u00a0n\u00fameros 1\" width=\"365\" height=\"349\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-6.png 365w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-6-300x287.png 300w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Na primeira etapa, voc\u00ea precisa escolher a\u00a0op\u00e7\u00e3o\u00a0Delimitado\u00a0e clicar em\u00a0Avan\u00e7ar.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2252\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-7.png\" alt=\"Converter data\u00a0em\u00a0n\u00fameros 2\" width=\"401\" height=\"327\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-7.png 401w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-7-300x245.png 300w\" sizes=\"auto, (max-width: 401px) 100vw, 401px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Na segunda etapa, a partir da\u00a0se\u00e7\u00e3o\u00a0delimitadora\u00a0escolhe\u00a0Espa\u00e7o.\u00a0No painel de visualiza\u00e7\u00e3o mostrado abaixo, voc\u00ea pode ver as datas divididas em colunas.<\/li>\n<li>Clique em\u00a0Avan\u00e7ar.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2253\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-8.png\" alt=\"Converter data\u00a0em\u00a0n\u00fameros 3\" width=\"402\" height=\"372\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-8.png 402w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-8-300x278.png 300w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/p>\n<p style=\"text-align: justify;\">Na terceira etapa, defina o tipo de dados de cada coluna:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora no\u00a0painel de visualiza\u00e7\u00e3o,\u00a0clique na coluna de data e escolha a op\u00e7\u00e3o Data.<\/li>\n<li>No menu suspenso Data, voc\u00ea deve selecionar o formato de data em que suas datas ser\u00e3o exibidas.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2254\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-9.png\" alt=\"Converter data\u00a0em\u00a0n\u00fameros 4\" width=\"402\" height=\"423\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-9.png 402w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-9-285x300.png 285w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/p>\n<p style=\"text-align: justify;\">Suponha que as datas estejam aparecendo no formato m\u00eas \/ dia \/ ano, em seguida, escolha o MDY.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Depois disso, para cada coluna restante, deve-se escolher a op\u00e7\u00e3o\u00a0\u201cN\u00e3o importar coluna (pular)\u201d\u00a0.<\/li>\n<li>Toque na\u00a0op\u00e7\u00e3o\u00a0Concluir\u00a0para converter as datas do formato de texto em datas reais.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2255\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-10.png\" alt=\"Converter data\u00a0em\u00a0n\u00fameros 5\" width=\"393\" height=\"375\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-10.png 393w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-10-300x286.png 300w\" sizes=\"auto, (max-width: 393px) 100vw, 393px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><strong><u>4 # Formatar\u00a0as\u00a0datas<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Ap\u00f3s a convers\u00e3o das datas de texto ou datas reais, \u00e9 hora de format\u00e1-los usando os\u00a0comandos Number Format.<\/p>\n<p style=\"text-align: justify;\">Aqui est\u00e3o alguns sinais que ajudam voc\u00ea a reconhecer as datas reais facilmente:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Se for contado como texto, as datas aparecer\u00e3o alinhadas \u00e0 direita.<\/li>\n<li>Voc\u00ea n\u00e3o ver\u00e1 ap\u00f3strofo no in\u00edcio da data.<\/li>\n<li>Quando voc\u00ea seleciona mais de uma data, o\u00a0Quick Calc\u00a0que est\u00e1 presente na\u00a0barra de status\u00a0s\u00f3 mostra a contagem, a contagem num\u00e9rica e a soma.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2256\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-11.png\" alt=\"Formatar\u00a0as\u00a0datas\" width=\"402\" height=\"345\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-11.png 402w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-11-300x257.png 300w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/p>\n<p style=\"text-align: justify;\">Para a formata\u00e7\u00e3o das datas, na faixa do Excel escolha os formatos de n\u00famero.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2257\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-12.png\" alt=\"Formatar\u00a0as\u00a0datas 1\" width=\"378\" height=\"310\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-12.png 378w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-12-300x246.png 300w\" sizes=\"auto, (max-width: 378px) 100vw, 378px\" \/><\/p>\n<p style=\"text-align: justify;\">Tudo funcionar\u00e1 perfeitamente agora, depois de converter o texto em datas reais.<\/p>\n<h3 style=\"text-align: justify;\"><strong><u>5 # Use\u00a0a\u00a0fun\u00e7\u00e3o VALUE<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Aqui est\u00e1 a sintaxe que voc\u00ea precisa usar:<\/p>\n<p style=\"text-align: justify;\">= VALUE (texto)<\/p>\n<p style=\"text-align: justify;\">Onde &#8216;texto&#8217; faz refer\u00eancia \u00e0 c\u00e9lula que possui a string de texto de data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2258\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-13.png\" alt=\"Use\u00a0a\u00a0fun\u00e7\u00e3o VALUE\" width=\"568\" height=\"169\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-13.png 568w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-13-300x89.png 300w\" sizes=\"auto, (max-width: 568px) 100vw, 568px\" \/><\/p>\n<p style=\"text-align: justify;\">A fun\u00e7\u00e3o VALUE \u00e9 usada principalmente para compatibilidade com outros programas de pasta de trabalho.\u00a0Com isso, voc\u00ea pode converter facilmente a string de texto que se parece com um n\u00famero em um n\u00famero real.<\/p>\n<p style=\"text-align: justify;\">\u00a0Em geral, \u00e9 \u00fatil para fixar qualquer tipo de n\u00famero, n\u00e3o apenas as datas.<\/p>\n<p style=\"text-align: justify;\"><strong>Notas:<\/strong><\/p>\n<ol style=\"text-align: justify;\">\n<li>Se a string de texto que voc\u00ea est\u00e1 usando n\u00e3o estiver no formato que \u00e9 bem reconhecido pelo Excel, ent\u00e3o ele certamente fornecer\u00e1 o #VALUE!\u00a0Erro.<\/li>\n<li>Para sua data, o Excel retornar\u00e1 os n\u00fameros de s\u00e9rie, ent\u00e3o voc\u00ea precisa definir o formato da c\u00e9lula como a data para fazer o n\u00famero de s\u00e9rie aparecer como uma data.<\/li>\n<\/ol>\n<h3 style=\"text-align: justify;\"><strong><u>6 # Fun\u00e7\u00e3o DATEVALUE<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Aqui est\u00e1 a sintaxe que voc\u00ea precisa usar:<\/p>\n<p style=\"text-align: justify;\">=\u00a0DATEVALUE\u00a0(\u00a0texto_data\u00a0)<\/p>\n<p style=\"text-align: justify;\">Onde &#8216;\u00a0date_text\u00a0&#8216; est\u00e1 referenciando a c\u00e9lula com a string de texto de data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2259\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-14.png\" alt=\"Fun\u00e7\u00e3o DATEVALUE\" width=\"573\" height=\"170\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-14.png 573w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-14-300x89.png 300w\" sizes=\"auto, (max-width: 573px) 100vw, 573px\" \/><\/p>\n<p style=\"text-align: justify;\">DATEVALUE \u00e9 muito semelhante \u00e0 fun\u00e7\u00e3o VALUE.\u00a0A \u00fanica diferen\u00e7a \u00e9 que ele pode converter a string de texto que aparece como uma data no n\u00famero de s\u00e9rie da data.<\/p>\n<p style=\"text-align: justify;\">Com a fun\u00e7\u00e3o VALUE, voc\u00ea tamb\u00e9m pode converter uma c\u00e9lula com data e hora formatada como texto.\u00a0Enquanto a fun\u00e7\u00e3o DATEVALUE ignora a se\u00e7\u00e3o de tempo da string de texto.<\/p>\n<h3 style=\"text-align: justify;\"><strong><u>7 #\u00a0Localizar\u00a0e substituir\u00a0<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Nas suas datas, se o decimal for usado como delimitador como este, 01\/01\/2014, o VALOR DATA e o VALOR n\u00e3o t\u00eam utilidade<\/p>\n<p style=\"text-align: justify;\">Nesses casos, usar Localizar e substituir do Excel \u00e9 a melhor op\u00e7\u00e3o.\u00a0Usando Find and Replace, voc\u00ea pode facilmente substituir decimal pela barra.\u00a0Isso converter\u00e1 a string de texto em um n\u00famero de s\u00e9rie do Excel.<\/p>\n<p style=\"text-align: justify;\">Aqui est\u00e3o as etapas para usar localizar e substituir:<\/p>\n<ol style=\"text-align: justify;\">\n<li>Escolha as datas em que o\u00a0Excel n\u00e3o reconhece o problema de formato de data.<\/li>\n<li>No teclado, pressione\u00a0CTRL + H.\u00a0Isso\u00a0abrir\u00e1 a caixa de di\u00e1logo localizar e substituir na tela.<\/li>\n<li>Agora, no campo\u00a0&#8216;Encontrar o que&#8217;\u00a0, coloque um decimal e, no\u00a0campo &#8216;substituir&#8217;\u00a0, uma barra.<\/li>\n<li>Toque na op\u00e7\u00e3o\u00a0&#8216;Substituir tudo&#8217;\u00a0.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2260\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-15.png\" alt=\"Localizar\u00a0e substituir\u00a0\" width=\"457\" height=\"200\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-15.png 457w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-15-300x131.png 300w\" sizes=\"auto, (max-width: 457px) 100vw, 457px\" \/><\/p>\n<p style=\"text-align: justify;\">O Excel agora pode identificar facilmente que seu texto est\u00e1 em n\u00famero e, assim, format\u00e1-lo automaticamente como uma data.<\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><strong>ARTIGO \u00daTIL:\u00a0<\/strong><a href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-encontrar-e-substituir-nao-trabalhando\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>6 Maneiras\u00a0Para\u00a0Fix Find Excel e substituir Emiss\u00e3o N\u00e3o trabalho<\/strong><\/a><\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify;\"><strong><u>8 # Verifica\u00e7\u00e3o de erro<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Por \u00faltimo, mas n\u00e3o menos importante, a op\u00e7\u00e3o que resta para\u00a0<strong>consertar Excel n\u00e3o reconhecer formato data <\/strong>\u00e9 usar o erro embutido ao verificar a op\u00e7\u00e3o do Excel.<\/p>\n<p style=\"text-align: justify;\">Essa ferramenta embutida sempre procura os n\u00fameros formatados como texto.<\/p>\n<p style=\"text-align: justify;\">Voc\u00ea pode identificar facilmente se h\u00e1 um erro, pois ele coloca um pequeno tri\u00e2ngulo verde no canto superior esquerdo da c\u00e9lula.\u00a0Ao selecionar esta c\u00e9lula, voc\u00ea ver\u00e1 um ponto de exclama\u00e7\u00e3o sobre ela.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2261\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-16.png\" alt=\"Verifica\u00e7\u00e3o de erro 1\" width=\"182\" height=\"136\" \/><\/p>\n<p style=\"text-align: justify;\">Ao atingir este ponto de exclama\u00e7\u00e3o, voc\u00ea obter\u00e1 mais algumas op\u00e7\u00f5es relacionadas ao seu texto:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2262\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-17.png\" alt=\"Verifica\u00e7\u00e3o de erro 2\" width=\"366\" height=\"241\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-17.png 366w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-17-300x198.png 300w\" sizes=\"auto, (max-width: 366px) 100vw, 366px\" \/><\/p>\n<p style=\"text-align: justify;\">No exemplo mostrado acima, o ano na data mostra apenas 2 d\u00edgitos.\u00a0Portanto, o Excel est\u00e1 perguntando em qual formato eu preciso converter o 19XX ou o 20XX.<\/p>\n<p style=\"text-align: justify;\">Voc\u00ea pode corrigir facilmente todas as datas listadas com esta op\u00e7\u00e3o de verifica\u00e7\u00e3o de erro.\u00a0Para isso, voc\u00ea precisa escolher todas as suas c\u00e9lulas com sequ\u00eancias de texto de data antes de atingir o ponto de exclama\u00e7\u00e3o na primeira c\u00e9lula selecionada.<\/p>\n<p style=\"text-align: justify;\">Etapas para ativar a op\u00e7\u00e3o de verifica\u00e7\u00e3o de erros:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Clique no \u00edcone do Office presente no canto superior esquerdo da pasta de trabalho do Excel aberta.\u00a0Agora v\u00e1 para\u00a0Op\u00e7\u00f5es\u00a0do\u00a0Excel&gt; F\u00f3rmulas<\/li>\n<li>Na se\u00e7\u00e3o de verifica\u00e7\u00e3o de erros, escolha a op\u00e7\u00e3o \u201c\u00a0ativar verifica\u00e7\u00e3o de erros em segundo plano\u201d.<\/li>\n<li>Agora, nas regras de verifica\u00e7\u00e3o de erros, escolha as\u00a0\u201cc\u00e9lulas contendo anos representados por 2 d\u00edgitos\u201d\u00a0e\u00a0\u201cn\u00famero formatado como texto ou precedido por um ap\u00f3strofo\u201d.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2263\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-18.png\" alt=\"Verifica\u00e7\u00e3o de erro 3\" width=\"594\" height=\"479\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-18.png 594w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Not-Recognizing-Date-Format-18-300x242.png 300w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><strong><u>Embrulhar:<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">Quando voc\u00ea importa dados para o Excel de qualquer outro programa, as chances s\u00e3o altas de que as datas estejam no formato de texto.\u00a0Isso significa que voc\u00ea n\u00e3o pode us\u00e1-lo muito em f\u00f3rmulas ou tabelas din\u00e2micas.<\/p>\n<p style=\"text-align: justify;\">Existem v\u00e1rias maneiras de\u00a0<strong>corrigir Excel n\u00e3o reconhecer formato data. <\/strong>O m\u00e9todo que voc\u00ea selecionar depender\u00e1 parcialmente de seu formato e de suas prefer\u00eancias por solu\u00e7\u00f5es sem f\u00f3rmula e com f\u00f3rmula.<\/p>\n<p style=\"text-align: justify;\">Ent\u00e3o, boa sorte com as corre\u00e7\u00f5es &#8230;!<\/p>\n<p style=\"text-align: justify;\"><br><center><a href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><img class='pt-cta-729' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-pt.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Todo o seu trabalho \u00e1rduo de manter os dados com a data adequada parece ter sido perdido porque, de repente, &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#more-2242\" aria-label=\"Read more about 8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":2265,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[694],"tags":[954,953,952,951],"class_list":["post-2242","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-erros","tag-consertar-excel-nao-reconhecendo-formato-data","tag-excel-nao-reconhece-o-formato-de-data","tag-formato-de-data-do-excel","tag-formato-de-data-nao-muda-no-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel<\/title>\n<meta name=\"description\" content=\"Este blog cont\u00e9m informa\u00e7\u00f5es detalhadas sobre por que o formato de data n\u00e3o muda no Excel. tamb\u00e9m tente 8 corre\u00e7\u00f5es diferentes para resolver o problema de n\u00e3o reconhecimento do formato de data do Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel\" \/>\n<meta property=\"og:description\" content=\"Este blog cont\u00e9m informa\u00e7\u00f5es detalhadas sobre por que o formato de data n\u00e3o muda no Excel. tamb\u00e9m tente 8 corre\u00e7\u00f5es diferentes para resolver o problema de n\u00e3o reconhecimento do formato de data do Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-25T10:39:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-23T12:06:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Fix-Excel-Not-Recognizing-Date-Format-pt.png\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"540\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Margret\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/margret1_arthur\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Margret\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#article\",\"isPartOf\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel\",\"datePublished\":\"2020-11-25T10:39:37+00:00\",\"dateModified\":\"2021-07-23T12:06:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data\"},\"wordCount\":1782,\"publisher\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Fix-Excel-Not-Recognizing-Date-Format-pt.png\",\"keywords\":[\"consertar Excel n\u00e3o reconhecendo formato data\",\"Excel n\u00e3o reconhece o formato de data\",\"Formato de data do Excel\",\"formato de data n\u00e3o muda no Excel\"],\"articleSection\":[\"Excel erros\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data\",\"url\":\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data\",\"name\":\"8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel\",\"isPartOf\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#primaryimage\"},\"image\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Fix-Excel-Not-Recognizing-Date-Format-pt.png\",\"datePublished\":\"2020-11-25T10:39:37+00:00\",\"dateModified\":\"2021-07-23T12:06:24+00:00\",\"description\":\"Este blog cont\u00e9m informa\u00e7\u00f5es detalhadas sobre por que o formato de data n\u00e3o muda no Excel. tamb\u00e9m tente 8 corre\u00e7\u00f5es diferentes para resolver o problema de n\u00e3o reconhecimento do formato de data do Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#primaryimage\",\"url\":\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Fix-Excel-Not-Recognizing-Date-Format-pt.png\",\"contentUrl\":\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Fix-Excel-Not-Recognizing-Date-Format-pt.png\",\"width\":960,\"height\":540,\"caption\":\"8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/pt.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#website\",\"url\":\"https:\/\/pt.repairmsexcel.com\/blog\/\",\"name\":\"Excel Arquivo Reparar Blog\",\"description\":\"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas\",\"publisher\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#organization\",\"name\":\"Excel Arquivo Reparar\",\"url\":\"https:\/\/pt.repairmsexcel.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Excel Arquivo Reparar\"},\"image\":{\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca\",\"name\":\"Margret\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"caption\":\"Margret\"},\"description\":\"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur\"],\"url\":\"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel","description":"Este blog cont\u00e9m informa\u00e7\u00f5es detalhadas sobre por que o formato de data n\u00e3o muda no Excel. tamb\u00e9m tente 8 corre\u00e7\u00f5es diferentes para resolver o problema de n\u00e3o reconhecimento do formato de data do Excel.","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:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data","og_locale":"en_US","og_type":"article","og_title":"8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel","og_description":"Este blog cont\u00e9m informa\u00e7\u00f5es detalhadas sobre por que o formato de data n\u00e3o muda no Excel. tamb\u00e9m tente 8 corre\u00e7\u00f5es diferentes para resolver o problema de n\u00e3o reconhecimento do formato de data do Excel.","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2020-11-25T10:39:37+00:00","article_modified_time":"2021-07-23T12:06:24+00:00","og_image":[{"width":960,"height":540,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Fix-Excel-Not-Recognizing-Date-Format-pt.png","type":"image\/png"}],"author":"Margret","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/margret1_arthur","twitter_misc":{"Written by":"Margret","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel","datePublished":"2020-11-25T10:39:37+00:00","dateModified":"2021-07-23T12:06:24+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data"},"wordCount":1782,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Fix-Excel-Not-Recognizing-Date-Format-pt.png","keywords":["consertar Excel n\u00e3o reconhecendo formato data","Excel n\u00e3o reconhece o formato de data","Formato de data do Excel","formato de data n\u00e3o muda no Excel"],"articleSection":["Excel erros"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data","url":"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data","name":"8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Fix-Excel-Not-Recognizing-Date-Format-pt.png","datePublished":"2020-11-25T10:39:37+00:00","dateModified":"2021-07-23T12:06:24+00:00","description":"Este blog cont\u00e9m informa\u00e7\u00f5es detalhadas sobre por que o formato de data n\u00e3o muda no Excel. tamb\u00e9m tente 8 corre\u00e7\u00f5es diferentes para resolver o problema de n\u00e3o reconhecimento do formato de data do Excel.","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Fix-Excel-Not-Recognizing-Date-Format-pt.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/11\/Fix-Excel-Not-Recognizing-Date-Format-pt.png","width":960,"height":540,"caption":"8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-nao-reconhece-formato-data#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"8 maneiras de corrigir o formato de data n\u00e3o reconhecido pelo Excel"}]},{"@type":"WebSite","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website","url":"https:\/\/pt.repairmsexcel.com\/blog\/","name":"Excel Arquivo Reparar Blog","description":"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas","publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization","name":"Excel Arquivo Reparar","url":"https:\/\/pt.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Excel Arquivo Reparar"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca","name":"Margret","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","caption":"Margret"},"description":"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.","sameAs":["https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/","https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur"],"url":"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret"}]}},"_links":{"self":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=2242"}],"version-history":[{"count":8,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2242\/revisions"}],"predecessor-version":[{"id":2245,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2242\/revisions\/2245"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/2265"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=2242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=2242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=2242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}