I have a unique problem that usually a text to columns macro fixes as per below.
Columns("D:D").Select Selection.texttocolumns Destination:=Range("D1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _ :=Array(1, 1), TrailingMinusNumbers:=True
My problem is as below (please refer to problem jpg). The group dates won't group with the other dates.
I've tried everything from copy and paste special as values
Then changing the date format to
This is super frustrating.