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? 
Google sheets recently changed American datetime format, how do I change it back?
google spreadsheets;formatting;date