ungrouped dates

Copper Contributor

Hello, I have a list of dates - some of them are grouped by the year in the filtering and some are not (see below).

How can I fix it so that all of the dates will be grouped by the year?



3 Replies


I suspect that the "dates" at the bottom are actually text values instead of real dates.

If you set the horizontal alignment of the column to General, check whether those values are left-aligned.

You are right, they are not left-aligned.
What should I do then?


Try Data > Text to Columns.