Forum Discussion
Date format
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.
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 Replies
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.
- Hi Sergei thank so much! it worked for me.
Bianca_Lucy , you are welcome
