We are aware of the issue with the badge emails resending to everyone, we apologise for the inconvenience - learn more here.

Forum Discussion

Paul B.85's avatar
Paul B.85
New member | Level 1
10 years ago

Cannot Change Excel online date format

Hi, 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. I've already checked the date format of my Dropbox account and it ...
FAQ
Microsoft
Microsoft Office
Third Party Integrations
  • Karsten H.1's avatar
    Karsten H.1
    9 years ago

    @PAUL: You can change the Excel date display format but the Excel date input format is determined by the regional settings of the environment Excel is running in (Web/Windows/Mac/Mobile).

    If you want to display date cells correctly you can use the date detection in this sheet:
    https://dl.dropboxusercontent.com/u/4737890/RegionalSettings.xlsx

    and then use the formula "=TEXT([YourDateCellReference],C8)" to format date cells in Excel.

    With English (Australian) settings on Windows the formula "=TEXT(38000,C8)" shows "14/02/2004".

    The 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.

Karsten H.1's avatar
Karsten H.1
Helpful | Level 5

@PAUL: You can change the Excel date display format but the Excel date input format is determined by the regional settings of the environment Excel is running in (Web/Windows/Mac/Mobile).

If you want to display date cells correctly you can use the date detection in this sheet:
https://dl.dropboxusercontent.com/u/4737890/RegionalSettings.xlsx

and then use the formula "=TEXT([YourDateCellReference],C8)" to format date cells in Excel.

With English (Australian) settings on Windows the formula "=TEXT(38000,C8)" shows "14/02/2004".

The 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.

mazama's avatar
mazama
New member | Level 2
8 years ago

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. 

 

Will a simple resolution to this ever be achieved?

 

[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 here.]

About Integrations

Find solutions to issues with third-party integrations from the Dropbox Community. Share advice and help members with their integration questions.

Need more support

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X or Facebook.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!