I have a cell formatted as YYYY-MM-DD, but when I use
Code: Select all
CTRL+fullstop
In other words, instead of getting 2022-05-20 I get 22-05-20.
I have tested this on an existing sheet and on a completely new sheet.
I am on MacOS 10.14.6 and am using FreeOffice 2021.