{"id":710,"date":"2023-09-25T20:38:44","date_gmt":"2023-09-25T20:38:44","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/formato-de-data\/"},"modified":"2023-12-06T11:34:39","modified_gmt":"2023-12-06T11:34:39","slug":"formato-de-data","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/formato-de-data\/","title":{"rendered":"Como aplicar o formato de data via atalho do excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-1228476954\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><div class=\"excel-before-content\" id=\"excel-1942904419\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Muitas vezes, quando voc\u00ea extrai dados contendo datas como valores em c\u00e9lulas de qualquer ferramenta, ERP ou software, \u00e9 poss\u00edvel que esses valores estejam em formatos de data num\u00e9ricos ou n\u00e3o uniformes.<\/p><p> Para transformar esses valores em um formato de data padr\u00e3o, voc\u00ea precisa aplicar o formato de data usando o atalho r\u00e1pido do teclado, que converter\u00e1 os valores em um formato de data padr\u00e3o.<\/p><h2 class=\"wp-block-heading\"> Atalho de teclado para aplicar formato de data no Excel<\/h2><p> <kbd>Ctrl<\/kbd> + <kbd>Shift<\/kbd> + <kbd>#<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-74553\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-format-de-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"formato de data de tecla de atalho\" width=\"718\" height=\"282\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Etapas para aplicar o formato de data usando o atalho do teclado<\/h2><ol><li> Primeiro, selecione as c\u00e9lulas ou colunas que possuem datas como valores. <br><img loading=\"lazy\" decoding=\"async\" title=\"2 valores de data de sele\u00e7\u00e3o\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selectionnez-les-valeurs-de-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-date-values\" width=\"226\" height=\"226\"><\/li><li> Depois disso, basta pressionar as teclas \u201cCtrl + Shift + #\u201d juntas e seus valores de data ser\u00e3o convertidos em um formato de data uniforme. <br><img loading=\"lazy\" decoding=\"async\" title=\"Formato de data 3 uniforme\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-format-de-date-uniforme.png\" sizes=\"auto, \" srcset=\"\" alt=\"uniform-date-format\" width=\"228\" height=\"224\"><\/li><\/ol><div class=\"gb-container gb-container-2116538e gb-container-mt\"> <a class=\"gb-button gb-button-f7d2c131 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/pt\/atalhos-do-teclado\/\">Atalhos de teclado do Excel<\/a><h2 class=\"gb-headline gb-headline-7ed68554 gb-headline-text gb-headline-mt-heading\"> Mais atalhos <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-edeef538 gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-6ab6fbc6\"><div class=\"gb-container gb-container-6ab6fbc6\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/formato-de-moeda\/\">Aplicar formato de moeda<\/a><\/li><li> Porcentagem de formato<\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/formato-de-hora\/\">Aplicar formato de hora<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-766d598b\"><div class=\"gb-container gb-container-766d598b\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-710","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como aplicar o formato de data via atalho do Excel?<\/title>\n<meta name=\"description\" content=\"Atalho de teclado para aplicar o formato de data a uma c\u00e9lula ou intervalo de m\u00faltiplas c\u00e9lulas. Voc\u00ea tamb\u00e9m aprender\u00e1 a\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/pt\/formato-de-data\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como aplicar o formato de data via atalho do Excel?\" \/>\n<meta property=\"og:description\" content=\"Atalho de teclado para aplicar o formato de data a uma c\u00e9lula ou intervalo de m\u00faltiplas c\u00e9lulas. Voc\u00ea tamb\u00e9m aprender\u00e1 a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/formato-de-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:34:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-format-de-date.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/formato-de-data\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/formato-de-data\/\",\"name\":\"Como aplicar o formato de data via atalho do Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/formato-de-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/formato-de-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-format-de-date.png\",\"datePublished\":\"2023-09-25T20:38:44+00:00\",\"dateModified\":\"2023-12-06T11:34:39+00:00\",\"description\":\"Atalho de teclado para aplicar o formato de data a uma c\u00e9lula ou intervalo de m\u00faltiplas c\u00e9lulas. Voc\u00ea tamb\u00e9m aprender\u00e1 a\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/formato-de-data\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/formato-de-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/formato-de-data\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-format-de-date.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-format-de-date.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/formato-de-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como aplicar o formato de data via atalho do excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como aplicar o formato de data via atalho do Excel?","description":"Atalho de teclado para aplicar o formato de data a uma c\u00e9lula ou intervalo de m\u00faltiplas c\u00e9lulas. Voc\u00ea tamb\u00e9m aprender\u00e1 a","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:\/\/exceladvisor.org\/pt\/formato-de-data\/","og_locale":"pt_PT","og_type":"article","og_title":"Como aplicar o formato de data via atalho do Excel?","og_description":"Atalho de teclado para aplicar o formato de data a uma c\u00e9lula ou intervalo de m\u00faltiplas c\u00e9lulas. Voc\u00ea tamb\u00e9m aprender\u00e1 a","og_url":"https:\/\/exceladvisor.org\/pt\/formato-de-data\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:34:39+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-format-de-date.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/formato-de-data\/","url":"https:\/\/exceladvisor.org\/pt\/formato-de-data\/","name":"Como aplicar o formato de data via atalho do Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/formato-de-data\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/formato-de-data\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-format-de-date.png","datePublished":"2023-09-25T20:38:44+00:00","dateModified":"2023-12-06T11:34:39+00:00","description":"Atalho de teclado para aplicar o formato de data a uma c\u00e9lula ou intervalo de m\u00faltiplas c\u00e9lulas. Voc\u00ea tamb\u00e9m aprender\u00e1 a","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/formato-de-data\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/formato-de-data\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/formato-de-data\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-format-de-date.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-format-de-date.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/formato-de-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como aplicar o formato de data via atalho do excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/710","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=710"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/710\/revisions"}],"predecessor-version":[{"id":843,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/710\/revisions\/843"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}