Proton Sheets - Additional Date Formats
Currently it appears the only possible Date format for Date types in Proton Sheets is mm/dd/yyyy, which is US centric.
Would appreciate additionally including other date arrangements, perhaps:
dd/mm/yyyy (Common globally)
dd/mm/yy
yyyy/mm/dd (ISO 8601)
dd/mmm/yyyy
Would suggest dd/mm/yyyy given that it's arguably the most common format globally and yyyy-mm-dd given that it's the ISO 8601 international standard used heavily in software around the world should be priorities 👍
-
lain
commented
Ironically I'm having the opposite issue: American getting the global format.
-
paulssn
commented
Also see this more general localization idea: https://protonmail.uservoice.com/forums/932839-proton-drive/suggestions/50795321-location-settings-for-sheets-date-numbers-curr
Also covers numbers/currency. -
cyriel
commented
Totally agree. As a European, my brain doesn't compute the month-day-year format we're stuck with now.
-
as
commented
Yeah unusable without this feature, also need to not default to USD
-
Matthias Herbst
commented
Need that feature too. Not usable without german date formatting. (dd.mm.yyyy)
-
Aleksandra
commented
This, plus date using dots instead of slashes, with the full month number instead of dd/m/yyyy when the month is a single digit!
Also, more options for other formats such as numbers – it's absurd to force the American comma as thousand separator and dot as decimal separator. I'm not going to use this until different formats are available.
-
Cédric Mallet
commented
it is quite embarrassing for a Swiss company to select the US date format and make it non-modifiable. None of us wants to read a date with the month first. At first I though the sheet would use my browser or system region but even with everything in French or UK English I still have the dates in MM/DD/YYYY. It's a no go to use Proton Sheets for me.
-
Hanna commented
I always use YYYY-MM-DD, it's the easiest way for me and easiest to sort. I have it in all my documents
-
imaginewagons
commented
This feature is super important for me. I'm migrating from google as a Proton paying customer.
-
Mistral
commented
yeah. at least ISO-standard date formats should be supported.
-
Matthias
commented
I am flabbergasted Proton Sheets launched without such a basic and essential feature... and then even defaults to the US date format even though being an european service. Since Proton Docs was released, I was hoping for a Proton Sheets so I could finally leave Google Docs behind. When that finally happened, I was over the moon... but in its current state, it is simply not able to compete with or be a replacement for Google Docs Sheets. :-(
Hopefully the date and time format gets as customizable as it is with Google Docs. That would be a great step forward.
-
Leo Moons
commented
DD/MM/YYYY is my favorite, and it is not easy to convert with formulae.
-
Jon Saville
commented
Agreed that we should be able to specify this manually, but Sheets should pick up the default from the browser environment like any other application.
-
ais
commented
There should be an option to provide a date format.
I need YYYY-MM-DD, which is easy to enter myself if given the option.
-
Tringhamm
commented
When importing an existent spreadsheet that I created with Google Drive, I was able to use cells with DD/MM/YYYY. It was recognized as a date field. But indeed it is necessary to have more formats.
-
Anonymous
commented
đź’Ż I imagine date formatting will quickly become an issue for this global audience.
-
Pavel
commented
And dd.mm.yyyy (used for example in the Czech Republic) would be great.