<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Cannot Change Excel online date format  in Integrations</title>
    <link>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101879#M7291</link>
    <description>&lt;P&gt;Hi Stephen! That's an issue we should probably bring forward with Excel's Support:&lt;/P&gt;

&lt;P&gt;&lt;A href="https://support2.microsoft.com/ask-community/office/excel" rel="nofollow noreferrer"&gt;https://support2.microsoft.com/ask-community/office/excel&lt;/A&gt;&lt;/P&gt;</description>
    <pubDate>Mon, 06 Jul 2015 19:09:31 GMT</pubDate>
    <dc:creator>DD1</dc:creator>
    <dc:date>2015-07-06T19:09:31Z</dc:date>
    <item>
      <title>Cannot Change Excel online date format</title>
      <link>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101876#M7288</link>
      <description>&lt;P&gt;Hi, &lt;BR /&gt;I live in Australia and I need to change the date format in Excel to the proper format. It currently displays as mm/dd/yyyy. &lt;BR /&gt;I've already checked the date format of my Dropbox account and it is already set to dd/mm/yyyy/ &lt;BR /&gt;How do I get Excel online to honour the correct format. &lt;BR /&gt;Paul&lt;/P&gt;</description>
      <pubDate>Thu, 28 Jul 2022 14:43:05 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101876#M7288</guid>
      <dc:creator>Paul B.85</dc:creator>
      <dc:date>2022-07-28T14:43:05Z</dc:date>
    </item>
    <item>
      <title>Re: Cannot Change Excel online date format</title>
      <link>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101877#M7289</link>
      <description>&lt;P&gt;Hi Paul! This appears to be more of an Excel issue than of a Dropbox issue.. but you can change the formatting of Excel files in the excel settings. Just found this online, maybe it helps. &lt;A href="http://www.excel-easy.com/basics/format-cells.html" rel="nofollow noreferrer"&gt;http://www.excel-easy.com/basics/format-cells.html&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Fri, 05 Jun 2015 21:34:26 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101877#M7289</guid>
      <dc:creator>DD1</dc:creator>
      <dc:date>2015-06-05T21:34:26Z</dc:date>
    </item>
    <item>
      <title>Re: Cannot Change Excel online date format</title>
      <link>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101878#M7290</link>
      <description>&lt;P&gt;Flynn, that does not answer Paul's question...that is an article on Microsoft Excel NOT Excel Online which is the issue that all Australian users are facing. &lt;/P&gt;

&lt;P&gt;Format Cells is not an option in Excel Online as there is only limited functionality available. The only option around dates is Short Date or Long Date.&lt;/P&gt;</description>
      <pubDate>Mon, 06 Jul 2015 08:53:41 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101878#M7290</guid>
      <dc:creator>Stephen B.21</dc:creator>
      <dc:date>2015-07-06T08:53:41Z</dc:date>
    </item>
    <item>
      <title>Re: Cannot Change Excel online date format</title>
      <link>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101879#M7291</link>
      <description>&lt;P&gt;Hi Stephen! That's an issue we should probably bring forward with Excel's Support:&lt;/P&gt;

&lt;P&gt;&lt;A href="https://support2.microsoft.com/ask-community/office/excel" rel="nofollow noreferrer"&gt;https://support2.microsoft.com/ask-community/office/excel&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 06 Jul 2015 19:09:31 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101879#M7291</guid>
      <dc:creator>DD1</dc:creator>
      <dc:date>2015-07-06T19:09:31Z</dc:date>
    </item>
    <item>
      <title>Re: Cannot Change Excel online date format</title>
      <link>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101880#M7292</link>
      <description>&lt;P&gt;I thought so, is that something you can raise Flynn?&lt;/P&gt;</description>
      <pubDate>Mon, 06 Jul 2015 19:23:12 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101880#M7292</guid>
      <dc:creator>Stephen B.21</dc:creator>
      <dc:date>2015-07-06T19:23:12Z</dc:date>
    </item>
    <item>
      <title>Re: Cannot Change Excel online date format</title>
      <link>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101881#M7293</link>
      <description>&lt;P&gt;Hey Stephen! I could, though it's probably easier to troubleshoot if someone writes in that is affected by the issue, so that you could send screenshots and such. What do you think?&lt;/P&gt;</description>
      <pubDate>Mon, 06 Jul 2015 19:27:36 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101881#M7293</guid>
      <dc:creator>DD1</dc:creator>
      <dc:date>2015-07-06T19:27:36Z</dc:date>
    </item>
    <item>
      <title>Re: Cannot Change Excel online date format</title>
      <link>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101882#M7294</link>
      <description>&lt;P&gt;Sure thing Flynn, I have raised the question in the Microsoft Community Forum. FYI, here is the link:&lt;BR /&gt;
&lt;A href="http://answers.microsoft.com/en-us/office/forum/officeonline-excel_online/excel-online-date-format-can-not-be-changed/5c543b14-d391-45e1-8137-f72e581b13ac?tm=1436235941067" rel="nofollow noreferrer"&gt;http://answers.microsoft.com/en-us/office/forum/officeonline-excel_online/excel-online-date-format-can-not-be-changed/5c543b14-d391-45e1-8137-f72e581b13ac?tm=1436235941067&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 07 Jul 2015 09:27:56 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101882#M7294</guid>
      <dc:creator>Stephen B.21</dc:creator>
      <dc:date>2015-07-07T09:27:56Z</dc:date>
    </item>
    <item>
      <title>Re: Cannot Change Excel online date format</title>
      <link>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101883#M7295</link>
      <description>&lt;P&gt;I tested a some&amp;nbsp;cases, here is what I found out:&lt;/P&gt;
&lt;P&gt;Dropbox&amp;nbsp;Web Preferences -&amp;gt; Language: Direct effect on Excel Online date format&lt;BR /&gt;Dropbox&amp;nbsp;Web Preferences -&amp;gt; Date format: No effect on&amp;nbsp;Excel Online date format&lt;BR /&gt;Chrome (Browser) Preferences -&amp;gt;&amp;nbsp;No effect on&amp;nbsp;Excel Online date format&lt;/P&gt;
&lt;P&gt;Dropbox Display Language = German -&amp;gt; Excel date format = TT.MM.JJJJ (= DD.MM.YYYY)&lt;BR /&gt;Dropbox Display Language = Russian&amp;nbsp;-&amp;gt; Excel date format = ДД.ММ.ГГГГ (= DD.MM.YYYY)&lt;BR /&gt;Dropbox Display Language = Chinese (Simpl.)&amp;nbsp;-&amp;gt; Excel date format = YYYY/MM/DD&lt;BR /&gt;Dropbox Display Language = English (UK) -&amp;gt; Excel date format = &lt;STRONG&gt;MM/DD/YYYY&lt;/STRONG&gt;&lt;BR /&gt;Dropbox Display Language = English (US) -&amp;gt; Excel date format = MM/DD/YYYY&lt;/P&gt;
&lt;P&gt;This leads to the assumption that it is the Dropbox language setting that causes UK/AU/CA users to see wrong&amp;nbsp;date formats. I also tested on SharePoint Online (Office 365) with the following results:&lt;/P&gt;
&lt;P&gt;SharePoint Site Regional Setting = German -&amp;gt; Excel date format = TT.MM.JJJJ&lt;BR /&gt;SharePoint Site Regional Setting = Russian&amp;nbsp;-&amp;gt; Excel date format = ДД.ММ.ГГГГ&lt;BR /&gt;SharePoint Site Regional Setting = Chinese&amp;nbsp;(China) -&amp;gt; Excel date format = YYYY/MM/DD&lt;BR /&gt;SharePoint Site Regional Setting = English (UK) -&amp;gt; Excel date format = DD/MM/YYYY&lt;BR /&gt;SharePoint Site Regional Setting = English (US) -&amp;gt; Excel date format = MM/DD/YYYY&lt;BR /&gt;SharePoint Site Regional Setting = English (CA) -&amp;gt; Excel date format = YYYY/MM/DD&lt;BR /&gt;&lt;BR /&gt;It seems that it is somehow possible to tell Excel Online the exact regional format.&lt;/P&gt;
&lt;P&gt;Here is the Excelsheet I used for testing:&amp;nbsp;&lt;A href="https://dl.dropboxusercontent.com/u/4737890/RegionalSettings.xlsx" rel="nofollow noreferrer"&gt;https://dl.dropboxusercontent.com/u/4737890/RegionalSettings.xlsx&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 12 Jul 2016 21:34:44 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101883#M7295</guid>
      <dc:creator>Karsten H.1</dc:creator>
      <dc:date>2016-07-12T21:34:44Z</dc:date>
    </item>
    <item>
      <title>Re: Cannot Change Excel online date format</title>
      <link>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101884#M7296</link>
      <description>&lt;P&gt;@PAUL: You can change the Excel date &lt;STRONG&gt;display&amp;nbsp;format&lt;/STRONG&gt; but the Excel date &lt;STRONG&gt;input format&lt;/STRONG&gt; is determined&amp;nbsp;by the regional settings of the environment Excel is running in (Web/Windows/Mac/Mobile).&lt;/P&gt;
&lt;P&gt;If you want to display date cells correctly you can use the date detection in this sheet:&lt;BR /&gt;&lt;A href="https://dl.dropboxusercontent.com/u/4737890/RegionalSettings.xlsx" rel="nofollow noreferrer"&gt;https://dl.dropboxusercontent.com/u/4737890/RegionalSettings.xlsx&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;and then use the formula "=TEXT([YourDateCellReference],C8)" to format date cells in Excel.&lt;/P&gt;
&lt;P&gt;With English (Australian) settings on Windows the formula "=TEXT(38000,C8)" shows "14/02/2004".&lt;/P&gt;
&lt;P&gt;The&amp;nbsp;date format problem is one of the weaknesses of Excel. If you want to create internationalized worksheets that work in every country you have to detect the local regional settings and internationalize all formatting, input parsing and formula generating formulas.&lt;/P&gt;</description>
      <pubDate>Tue, 12 Jul 2016 21:51:53 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/101884#M7296</guid>
      <dc:creator>Karsten H.1</dc:creator>
      <dc:date>2016-07-12T21:51:53Z</dc:date>
    </item>
    <item>
      <title>Re: Cannot Change Excel online date format</title>
      <link>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/206385#M7297</link>
      <description>&lt;P&gt;This shouldnt be so complicated. How is the average excel user supposed to be able to do this? Without the correct date format, this makes managing date related spreadsheets on dropbox cumbersome and essentially useless.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Will a simple resolution to this ever be achieved?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#808080"&gt;&lt;SPAN class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qovuvz90zz76z3vz80z1yz79zhg5j6xz90z4yz75zz74z4o5z89zz87z7tz122zlm"&gt;&lt;I&gt;[This thread is now closed by moderators due to inactivity. If you're experiencing a similar behavior, feel free to start a new discussion in the Dropbox Community &lt;/I&gt;&lt;/SPAN&gt;&lt;SPAN class="attrlink url author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qovuvz90zz76z3vz80z1yz79zhg5j6xz90z4yz75zz74z4o5z89zz87z7tz122zlm"&gt;&lt;A class="attrlink" href="https://www.dropboxforum.com/t5/Ask-a-question/ct-p/101001000" target="_blank" rel="noreferrer nofollow noopener" data-target-href="https://www.dropboxforum.com/t5/Ask-a-question/ct-p/101001000"&gt;&lt;I&gt;here&lt;/I&gt;&lt;/A&gt;&lt;/SPAN&gt;&lt;SPAN class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qovuvz90zz76z3vz80z1yz79zhg5j6xz90z4yz75zz74z4o5z89zz87z7tz122zlm"&gt;&lt;I&gt;.]&lt;/I&gt;&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 26 Jun 2019 13:58:59 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Integrations/Cannot-Change-Excel-online-date-format/m-p/206385#M7297</guid>
      <dc:creator>mazama</dc:creator>
      <dc:date>2019-06-26T13:58:59Z</dc:date>
    </item>
  </channel>
</rss>

