CSV to Excel

Copper Contributor

I have imported data from a csv file into Excel. One column has date and time in it 20/8/2020 07:32:19. I need to format the column into a recognised date format so that I can filter by month

2 Replies

@Johan_Schoeman In your file, select column V. On the Data ribbon, select "Text to columns". Click through the first two steps. On the third, select Date and DMY. Now press Finish.

 

 

@Riny_van_Eekelen Fantastic Thank you so much