CSV to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1763210%22%20slang%3D%22en-US%22%3ECSV%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1763210%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20imported%20data%20from%20a%20csv%20file%20into%20Excel.%20One%20column%20has%20date%20and%20time%20in%20it%26nbsp%3B%3CSTRONG%3E20%2F8%2F2020%2007%3A32%3A19%3C%2FSTRONG%3E.%20I%20need%20to%20format%20the%20column%20into%20a%20recognised%20date%20format%20so%20that%20I%20can%20filter%20by%20month%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1763210%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1763265%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1763265%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F826081%22%20target%3D%22_blank%22%3E%40Johan_Schoeman%3C%2FA%3E%26nbsp%3BIn%20your%20file%2C%20select%20column%20V.%20On%20the%20Data%20ribbon%2C%20select%20%22Text%20to%20columns%22.%20Click%20through%20the%20first%20two%20steps.%20On%20the%20third%2C%20select%20Date%20and%20DMY.%20Now%20press%20Finish.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1763290%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1763290%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BFantastic%20Thank%20you%20so%20much%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@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.

 

 

Highlighted

@Riny_van_Eekelen Fantastic Thank you so much