Google sheets recently changed American datetime format, how do I change it back?
It used to default to using "MM/dd/yyyy" but as of a couple weeks ago now when I enter a date it defaults to "MM/dd" and I have to go manually reformat it.
And worst part is a column never "remembers" it's formating. Every time I open the sheet and start editing a date/time column I have to go back and remind Google Sheets that I want that column to be a date/time column formated as "MM/dd/yyyy".
Is there anyway to change my own date/time default back to "MM/dd/yyyy"? (Yes all my sheets are set to USA country.)
Is there anyway to make Google Sheets remember a column's formatting every time it closes and gets reopened?