Text to columns funtion

[dicken]

Hi,
I had column of dates mm/ dd / yyy , but they were acutally text so used text to columns to convert to dates,
fine, but for the order I would have liked the year first, but despite selecting 'date' ' ydm' from drop down I always got the the original
order but now as dates? any suggestions ?

RD

 

[RoryA]

If you're using TTC, that means you are doing this in Excel, not PQ or Power BI, yes?

 

[dicken]

If you're using TTC, that means you are doing this in Excel, not PQ or Power BI, yes?

Yes, sorry should have said.

RD