How do I get google sheets to consistently list date as DD/MM/YYYY ?
A cell formatted as DD/MM/YYYY displays that format but then the input window changes to MM/DD/YYYY.
The cell below is formatted using one of the standard options:
I'm trying to enter a date representing the 5th of October 2022 in DD/MM/YYYY and have it displayed in DD/MM/YYYY but it seems to have been interpreted as the 10th of May 2022 by the input window.
My PC's locale is set to a region that uses the DD/MM/YYYY format.