{"id":34729,"date":"2024-02-05T18:40:48","date_gmt":"2024-02-05T21:40:48","guid":{"rendered":"https:\/\/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:\/\/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:\/\/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:\/\/stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31.png 1446w, https:\/\/stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31-300x107.png 300w, https:\/\/stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31-1024x365.png 1024w, https:\/\/stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31-768x274.png 768w, https:\/\/stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31-1080x385.png 1080w, https:\/\/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:\/\/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:\/\/stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.54.png 1146w, https:\/\/stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.54-300x277.png 300w, https:\/\/stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.54-1024x947.png 1024w, https:\/\/stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.54-768x710.png 768w, https:\/\/stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.54-1080x999.png 1080w, https:\/\/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 v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data formatting error in Google Sheets - Stract<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/stract.to\/en\/support\/data-formatting-error-in-google-sheets\/\" \/>\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:\/\/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\/stract.tool\" \/>\n<meta property=\"og:image\" content=\"https:\/\/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:\\\/\\\/stract.to\\\/en\\\/support\\\/data-formatting-error-in-google-sheets\\\/\",\"url\":\"https:\\\/\\\/stract.to\\\/en\\\/support\\\/data-formatting-error-in-google-sheets\\\/\",\"name\":\"Data formatting error in Google Sheets - Stract\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/stract.to\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/stract.to\\\/en\\\/support\\\/data-formatting-error-in-google-sheets\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/stract.to\\\/en\\\/support\\\/data-formatting-error-in-google-sheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/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:\\\/\\\/stract.to\\\/en\\\/support\\\/data-formatting-error-in-google-sheets\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/stract.to\\\/en\\\/support\\\/data-formatting-error-in-google-sheets\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/stract.to\\\/en\\\/support\\\/data-formatting-error-in-google-sheets\\\/#primaryimage\",\"url\":\"https:\\\/\\\/stract.to\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/Captura-de-Tela-2024-02-05-as-15.39.31.png\",\"contentUrl\":\"https:\\\/\\\/stract.to\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/Captura-de-Tela-2024-02-05-as-15.39.31.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/stract.to\\\/en\\\/support\\\/data-formatting-error-in-google-sheets\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\\\/\\\/stract.to\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data formatting error in Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/stract.to\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/stract.to\\\/en\\\/\",\"name\":\"Stract\",\"description\":\"Alternativa ao Supermetrics e Adveronix\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/stract.to\\\/en\\\/?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":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/stract.to\/en\/support\/data-formatting-error-in-google-sheets\/","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:\/\/stract.to\/en\/support\/data-formatting-error-in-google-sheets\/","og_site_name":"Stract","article_publisher":"https:\/\/www.facebook.com\/stract.tool","og_image":[{"url":"https:\/\/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:\/\/stract.to\/en\/support\/data-formatting-error-in-google-sheets\/","url":"https:\/\/stract.to\/en\/support\/data-formatting-error-in-google-sheets\/","name":"Data formatting error in Google Sheets - Stract","isPartOf":{"@id":"https:\/\/stract.to\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/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:\/\/stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/stract.to\/en\/support\/data-formatting-error-in-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#primaryimage","url":"https:\/\/stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31.png","contentUrl":"https:\/\/stract.to\/wp-content\/uploads\/2024\/02\/Captura-de-Tela-2024-02-05-as-15.39.31.png"},{"@type":"BreadcrumbList","@id":"https:\/\/stract.to\/en\/support\/data-formatting-error-in-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/stract.to\/en\/"},{"@type":"ListItem","position":2,"name":"Data formatting error in Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/stract.to\/en\/#website","url":"https:\/\/stract.to\/en\/","name":"Stract","description":"Alternativa ao Supermetrics e Adveronix","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/stract.to\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/stract.to\/en\/wp-json\/wp\/v2\/suporte\/34729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stract.to\/en\/wp-json\/wp\/v2\/suporte"}],"about":[{"href":"https:\/\/stract.to\/en\/wp-json\/wp\/v2\/types\/suporte"}],"wp:attachment":[{"href":"https:\/\/stract.to\/en\/wp-json\/wp\/v2\/media?parent=34729"}],"wp:term":[{"taxonomy":"suporte-categoria","embeddable":true,"href":"https:\/\/stract.to\/en\/wp-json\/wp\/v2\/suporte-categoria?post=34729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}