I have a sheet where various data is entered through a form. Dates are picked on the form using the standard date picker provided by Google Forms.
Some dates in a column I can change the date format but others don't.
What is odd is that when I copy this column into a new sheet and then try and change the format these stubborn ones then change correctly.
I have made a copy of the sheet (editable) and removed private info and left the column in question. BTW: there are two other date columns and they have similar issues. The issues are not on the same row for most cases. So it's not row related.
Here's a short video where I show how I try to change the date format on the "bad" sheet, then I copied the culprit date entry to another sheet and then I can format it. I hope you can assist with a way to work around this bug.