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 👍
-
Olivia Smith
commented
How to Trace and Recover Stolen or Lost or Funds From Crypto and Bitcoin Investment Scam? Visit Apexshield Recovery
Consult Apexshield Recovery to Recover stolen btc, usdt ,usdc and other cryptocurrency from online trading investment scam.
This notable crypto recovery company was able to help me recover my stolen crypto a few days ago after I fell victim to a crypto investment scam.Apexshield Recovery is a very professional and highly recommended crypto recovery service, I never thought it was possible to recover crypto assets until I encountered Apexshield Recovery. Have you lost access to your wallet?, Is your wallet compromised?, Have you been a victim of a fake forex broker,bitcoin, romance and investment scam? worry no more. Apexshield Recovery is the best and i am a living testimony. Reach out to them via google, search "apexshield.online" to recover back your crypto now.
Their contact informations are belowEmail: Info@apexshield.online
Whatsapp : +19025176264
Website: https://apexshield.online/ -
Jonathan Benton
commented
I understand that if you need to start with just one date format, it makes sense to consider the US, which likely represents the largest user base—probably by a significant margin. From a business perspective, it’s logical to adopt their date format from the outset. However, date formats can be a sensitive issue for those of us living outside the US. I acknowledge that countries like Canada may not have a large enough population on their own, but the second most commonly used date format is dd/mm/yyyy. Many countries, when combined, likely approach the US population size. I trust that you will begin developing a solution that uses the US date format as the default while still allowing users to choose from a variety of formats.
-
Aleksi
commented
Definitely needs to have dd.mm.yyyy!
-
Christoph D
commented
Just signed up, so I can back this. This is important!
-
Sonia B
commented
Yes to this - it is mucking up my spreadsheets - I find it bizarre that a company based in Switzerland is using the US format which isn't used outside of the US!
Please, please fix it! -
Aled
commented
Unusable for me without dd/mm/yyyy.
-
markoise
commented
And please don't forget dd.mm.yyyy
-
R. Guezen
commented
Financial is also an issue. Defaults to USD and different ways to display those values. Euro is an afterthought under the very limited "Other currency" option. I do not need USD just like I don't need US dates, times notation.
-
lain
commented
Ironically I'm having the opposite issue: American getting the global format.
-
Charlie
commented
Formatting hours is a really useful option to me. However, being stuck with the AM/PM formatting is really annoying, especially considering that the 24h format is used in a lot of countries and is even the ISO 8601...
In short I would love to see the option in the formatting... The strangest thing is that it is available when using the date&hour format... Please be consistent and give the user the choice on the formatting they want to use :) -
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.