{"id":392,"date":"2018-07-11T01:00:40","date_gmt":"2018-07-11T04:00:40","guid":{"rendered":"https:\/\/timesheet.dovico.com\/blog\/?p=392"},"modified":"2025-08-25T14:27:52","modified_gmt":"2025-08-25T17:27:52","slug":"dovico-timesheet-formatting-dates-and-time-on-exporting","status":"publish","type":"post","link":"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/","title":{"rendered":"Dovico Timesheet: Formatting Dates and Numbers on Exporting"},"content":{"rendered":"\n

Why Your Date and Number Formats Look Wrong in Excel \u2014 And How to Fix It<\/strong><\/p><\/div>\n\n\n

Does your data display the wrong Date \/ Number formats when you export?<\/strong><\/p>\n

\"acs_0200\"<\/strong><\/p>\n

\n
\n
\n

When you use the Export function, now directly available within the newer views in Dovico Timesheet, the exported data may initially appear to be exported in the wrong date and number formats.<\/p>\n

This happens when you export to .xls or xlsx, or when you export in .csv, open the file in Excel and then use the \u201cText to Column\u201d function. This occurs because Excel determines the formatting for some columns to match the regional local settings used by your machine.\u00a0The same happens when you export from the Reports Builder or the Job Scheduler.<\/p>\n

Everything exports properly, If you use the other available export formats (PDF, RTF, HTML, TXT or PNG). In the following example, you’ll see Project Summary and then what you get when the data is exported into an XLSX format:<\/div>\n<\/div>\n<\/div>\n
\u00a0<\/div>\n
\n
\"report-export-decimals\"<\/div>\n
\u00a0<\/div>\n
This article applies to the most recent release of Dovico Timesheet V14<\/i><\/div>\n<\/div>\n
\n

Ones and zeros make the software; they don\u2019t make the company or the customer experience. Dovico is confidence, knowledge, and service. For 25 years, we have been helping thousands of customers around the world to deliver successful projects with proven project time and cost saving tools. \u00a0www.dovico.com<\/a><\/em><\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

Why Your Date and Number Formats Look Wrong in Excel \u2014 And How to Fix It Does your data display the wrong Date \/ Number formats when you export? When you use the Export function, now directly available within the newer views in Dovico Timesheet, the exported data may initially appear to be exported in the wrong date and number formats. This happens when you export to .xls or xlsx, or when you export in…<\/p>\n","protected":false},"author":3,"featured_media":903,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-392","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-get-more-time"],"featured_image_urls_v2":{"full":["https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200.jpg",4032,3024,false],"thumbnail":["https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200-150x150.jpg",150,150,true],"medium":["https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200-300x225.jpg",300,225,true],"medium_large":["https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200-768x576.jpg",768,576,true],"large":["https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200-1024x768.jpg",1024,768,true],"1536x1536":["https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200.jpg",1536,1152,false],"2048x2048":["https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200.jpg",2048,1536,false],"thoughts-blog":["https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200-700x500.jpg",700,500,true],"thoughts-header":["https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200-1280x1024.jpg",1280,1024,true]},"post_excerpt_stackable_v2":"

Why Your Date and Number Formats Look Wrong in Excel \u2014 And How to Fix It Does your data display the wrong Date \/ Number formats when you export? When you use the Export function, now directly available within the newer views in Dovico Timesheet, the exported data may initially appear to be exported in the wrong date and number formats. This happens when you export to .xls or xlsx, or when you export in .csv, open the file in Excel and then use the \u201cText to Column\u201d function. This occurs because Excel determines the formatting for some columns to…<\/p>\n","category_list_v2":"Get More Time<\/a>","author_info_v2":{"name":"Dovico","url":"https:\/\/timesheet.dovico.com\/blog\/author\/ejohnston\/"},"comments_num_v2":"0 comments","yoast_head":"\nDovico Timesheet: Formatting Dates and Numbers on Exporting - Dovico Blog<\/title>\n<meta name=\"description\" content=\"Exporting from Dovico Timesheet and seeing wrong date or number formats in Excel? Learn why this happens and how to avoid it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dovico Timesheet: Formatting Dates and Numbers on Exporting - Dovico Blog\" \/>\n<meta property=\"og:description\" content=\"Exporting from Dovico Timesheet and seeing wrong date or number formats in Excel? Learn why this happens and how to avoid it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/\" \/>\n<meta property=\"og:site_name\" content=\"Dovico Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-11T04:00:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-25T17:27:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200-1024x768.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dovico\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dovico\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/\",\"url\":\"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/\",\"name\":\"Dovico Timesheet: Formatting Dates and Numbers on Exporting - Dovico Blog\",\"isPartOf\":{\"@id\":\"https:\/\/timesheet.dovico.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200.jpg\",\"datePublished\":\"2018-07-11T04:00:40+00:00\",\"dateModified\":\"2025-08-25T17:27:52+00:00\",\"author\":{\"@id\":\"https:\/\/timesheet.dovico.com\/blog\/#\/schema\/person\/f3b591bcd0171f30ebf2582d9be2551d\"},\"description\":\"Exporting from Dovico Timesheet and seeing wrong date or number formats in Excel? Learn why this happens and how to avoid it.\",\"breadcrumb\":{\"@id\":\"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/#primaryimage\",\"url\":\"https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200.jpg\",\"contentUrl\":\"https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200.jpg\",\"width\":4032,\"height\":3024},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/timesheet.dovico.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dovico Timesheet: Formatting Dates and Numbers on Exporting\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/timesheet.dovico.com\/blog\/#website\",\"url\":\"https:\/\/timesheet.dovico.com\/blog\/\",\"name\":\"Dovico Blog\",\"description\":\"Give Time Meaning.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/timesheet.dovico.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/timesheet.dovico.com\/blog\/#\/schema\/person\/f3b591bcd0171f30ebf2582d9be2551d\",\"name\":\"Dovico\",\"description\":\"Helping teams track time and manage projects since 1993. Dovico\u2019s timesheet software makes time tracking simple, insightful, and scalable. Learn more at dovico.com.\",\"sameAs\":[\"https:\/\/www.dovico.com\"],\"url\":\"https:\/\/timesheet.dovico.com\/blog\/author\/ejohnston\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dovico Timesheet: Formatting Dates and Numbers on Exporting - Dovico Blog","description":"Exporting from Dovico Timesheet and seeing wrong date or number formats in Excel? Learn why this happens and how to avoid it.","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:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/","og_locale":"en_US","og_type":"article","og_title":"Dovico Timesheet: Formatting Dates and Numbers on Exporting - Dovico Blog","og_description":"Exporting from Dovico Timesheet and seeing wrong date or number formats in Excel? Learn why this happens and how to avoid it.","og_url":"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/","og_site_name":"Dovico Blog","article_published_time":"2018-07-11T04:00:40+00:00","article_modified_time":"2025-08-25T17:27:52+00:00","og_image":[{"width":1024,"height":768,"url":"https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200-1024x768.jpg","type":"image\/jpeg"}],"author":"Dovico","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dovico","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/","url":"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/","name":"Dovico Timesheet: Formatting Dates and Numbers on Exporting - Dovico Blog","isPartOf":{"@id":"https:\/\/timesheet.dovico.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/#primaryimage"},"image":{"@id":"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/#primaryimage"},"thumbnailUrl":"https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200.jpg","datePublished":"2018-07-11T04:00:40+00:00","dateModified":"2025-08-25T17:27:52+00:00","author":{"@id":"https:\/\/timesheet.dovico.com\/blog\/#\/schema\/person\/f3b591bcd0171f30ebf2582d9be2551d"},"description":"Exporting from Dovico Timesheet and seeing wrong date or number formats in Excel? Learn why this happens and how to avoid it.","breadcrumb":{"@id":"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/#primaryimage","url":"https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200.jpg","contentUrl":"https:\/\/timesheet.dovico.com\/blog\/wp-content\/uploads\/2018\/07\/acs_0200.jpg","width":4032,"height":3024},{"@type":"BreadcrumbList","@id":"https:\/\/timesheet.dovico.com\/blog\/2018\/07\/11\/dovico-timesheet-formatting-dates-and-time-on-exporting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/timesheet.dovico.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Dovico Timesheet: Formatting Dates and Numbers on Exporting"}]},{"@type":"WebSite","@id":"https:\/\/timesheet.dovico.com\/blog\/#website","url":"https:\/\/timesheet.dovico.com\/blog\/","name":"Dovico Blog","description":"Give Time Meaning.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/timesheet.dovico.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/timesheet.dovico.com\/blog\/#\/schema\/person\/f3b591bcd0171f30ebf2582d9be2551d","name":"Dovico","description":"Helping teams track time and manage projects since 1993. Dovico\u2019s timesheet software makes time tracking simple, insightful, and scalable. Learn more at dovico.com.","sameAs":["https:\/\/www.dovico.com"],"url":"https:\/\/timesheet.dovico.com\/blog\/author\/ejohnston\/"}]}},"_links":{"self":[{"href":"https:\/\/timesheet.dovico.com\/blog\/wp-json\/wp\/v2\/posts\/392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/timesheet.dovico.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/timesheet.dovico.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/timesheet.dovico.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/timesheet.dovico.com\/blog\/wp-json\/wp\/v2\/comments?post=392"}],"version-history":[{"count":28,"href":"https:\/\/timesheet.dovico.com\/blog\/wp-json\/wp\/v2\/posts\/392\/revisions"}],"predecessor-version":[{"id":6962,"href":"https:\/\/timesheet.dovico.com\/blog\/wp-json\/wp\/v2\/posts\/392\/revisions\/6962"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/timesheet.dovico.com\/blog\/wp-json\/wp\/v2\/media\/903"}],"wp:attachment":[{"href":"https:\/\/timesheet.dovico.com\/blog\/wp-json\/wp\/v2\/media?parent=392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/timesheet.dovico.com\/blog\/wp-json\/wp\/v2\/categories?post=392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/timesheet.dovico.com\/blog\/wp-json\/wp\/v2\/tags?post=392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}