Date format

[Bianca_Lucy]

I have CSV files that contain dates in different formats. I see some of them are text, others are dates. I would like to change all dates to the dd/mm/yyyy format. 

I tried to extract using =text(left, right, mid) didn't work. Also, I tried to change the date format direct. 

I've changed manually using queries on Power BI but this is not worth it as soon I have more than 8 spreadsheets with a similar issue.

Many thanks for any help. 

[#2 · Accepted solution]

@Bianca_Lucy 

Select entire column B, on ribbon Data-> Text to Columns, on third step of the wizard select  Date and MDY.

Save file as Excel one (.xlsx), CSV is actually text file and contains no formatting.

[#3]

Hi Sergei thank so much! it worked for me.

[#4]

@Bianca_Lucy , you are welcome