Respect Custom Date Format When Entering Dates
In Proton Sheets, when a column is formatted with a custom date format such as DD/MM/YY, entering 07/02/26 is interpreted as February 7 instead of July 2, depending on the regional settings.
Currently, the only workaround is to change the spreadsheet's location settings.
Requested improvement: Date parsing should respect the explicitly selected cell or column date format rather than relying on the spreadsheet's regional settings. If the format is DD/MM/YY, entering 07/02/26 should always be interpreted as 7 February, regardless of locale.
This would make custom date formatting predictable and avoid unnecessary changes to regional settings.
4
votes