I have a spreadsheet, where one column has dates formatted in two different ways
Examples
5/16/77
OR
08/22/78
For the cells where the month has leading zero, the dates are not grouped by year in the filter drop down. If there is no leading zero, in the filter drop down they are grouped by year.
I have tried to reformat the entire column, but this does not change.
Additionally, when I export this spreadsheet/table into excel, the dates that have the leading zero do not import and these cells are blank.
Please advise on how to reformat.
Thanks.