{"id":34729,"date":"2024-02-05T18:40:48","date_gmt":"2024-02-05T21:40:48","guid":{"rendered":"https:\/\/hml2.stract.to\/suporte\/data-formatting-error-in-google-sheets\/"},"modified":"2024-02-05T18:40:48","modified_gmt":"2024-02-05T21:40:48","slug":"data-formatting-error-in-google-sheets","status":"publish","type":"suporte","link":"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/","title":{"rendered":"Data formatting error in Google Sheets"},"content":{"rendered":"<p><iframe loading=\"lazy\" title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/sW3kENo9Zwo?si=oMw4QANJ4X8-XWZF&amp;feature=oembed&amp;controls=1&amp;rel=0&amp;autohide=1\" width=\"100%\" height=\"515\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>When you are extracting data into Google Sheets and notice that the values appear formatted as dates, there is a simple solution.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-16483\" src=\"https:\/\/hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31.png\" alt=\"\" width=\"1446\" height=\"516\" srcset=\"https:\/\/www.hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31.png 1446w, https:\/\/www.hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31-300x107.png 300w, https:\/\/www.hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31-1024x365.png 1024w, https:\/\/www.hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31-768x274.png 768w, https:\/\/www.hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31-1080x385.png 1080w, https:\/\/www.hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31-600x214.png 600w\" sizes=\"auto, (max-width: 1446px) 100vw, 1446px\" \/><\/p>\n<p> Click on the &#8216;More Formatting&#8217; menu and then choose the &#8216;Number&#8217; option to correct the formatting.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-16484\" src=\"https:\/\/hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.54.png\" alt=\"\" width=\"1146\" height=\"1060\" srcset=\"https:\/\/www.hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.54.png 1146w, https:\/\/www.hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.54-300x277.png 300w, https:\/\/www.hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.54-1024x947.png 1024w, https:\/\/www.hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.54-768x710.png 768w, https:\/\/www.hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.54-1080x999.png 1080w, https:\/\/www.hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.54-600x555.png 600w\" sizes=\"auto, (max-width: 1146px) 100vw, 1146px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; When you are extracting data into Google Sheets and notice that the values appear formatted as dates, there is a simple solution. Click on the &#8216;More Formatting&#8217; menu and then choose the &#8216;Number&#8217; option to correct the formatting.<\/p>\n","protected":false},"featured_media":0,"template":"","suporte-categoria":[104],"class_list":["post-34729","suporte","type-suporte","status-publish","hentry","suporte-categoria-comece-aqui-en"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data formatting error in Google Sheets - Stract<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data formatting error in Google Sheets - Stract\" \/>\n<meta property=\"og:description\" content=\"&nbsp; When you are extracting data into Google Sheets and notice that the values appear formatted as dates, there is a simple solution. Click on the &#8216;More Formatting&#8217; menu and then choose the &#8216;Number&#8217; option to correct the formatting.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Stract\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hml2.stract.tool\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@stract_to\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/\",\"url\":\"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/\",\"name\":\"Data formatting error in Google Sheets - Stract\",\"isPartOf\":{\"@id\":\"https:\/\/hml2.stract.to\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31.png\",\"datePublished\":\"2024-02-05T21:40:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#primaryimage\",\"url\":\"https:\/\/hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31.png\",\"contentUrl\":\"https:\/\/hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/www.hml2.stract.to\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data formatting error in Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hml2.stract.to\/#website\",\"url\":\"https:\/\/hml2.stract.to\/\",\"name\":\"Stract\",\"description\":\"Alternativa ao Supermetrics e Adveronix\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hml2.stract.to\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data formatting error in Google Sheets - Stract","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Data formatting error in Google Sheets - Stract","og_description":"&nbsp; When you are extracting data into Google Sheets and notice that the values appear formatted as dates, there is a simple solution. Click on the &#8216;More Formatting&#8217; menu and then choose the &#8216;Number&#8217; option to correct the formatting.","og_url":"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/","og_site_name":"Stract","article_publisher":"https:\/\/www.facebook.com\/hml2.stract.tool","og_image":[{"url":"https:\/\/hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@stract_to","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/","url":"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/","name":"Data formatting error in Google Sheets - Stract","isPartOf":{"@id":"https:\/\/hml2.stract.to\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31.png","datePublished":"2024-02-05T21:40:48+00:00","breadcrumb":{"@id":"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#primaryimage","url":"https:\/\/hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31.png","contentUrl":"https:\/\/hml2.stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hml2.stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/www.hml2.stract.to\/en\/"},{"@type":"ListItem","position":2,"name":"Data formatting error in Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/hml2.stract.to\/#website","url":"https:\/\/hml2.stract.to\/","name":"Stract","description":"Alternativa ao Supermetrics e Adveronix","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hml2.stract.to\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.hml2.stract.to\/en\/wp-json\/wp\/v2\/suporte\/34729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hml2.stract.to\/en\/wp-json\/wp\/v2\/suporte"}],"about":[{"href":"https:\/\/www.hml2.stract.to\/en\/wp-json\/wp\/v2\/types\/suporte"}],"wp:attachment":[{"href":"https:\/\/www.hml2.stract.to\/en\/wp-json\/wp\/v2\/media?parent=34729"}],"wp:term":[{"taxonomy":"suporte-categoria","embeddable":true,"href":"https:\/\/www.hml2.stract.to\/en\/wp-json\/wp\/v2\/suporte-categoria?post=34729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}