Forum Discussion
Solved
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(le...
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.
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
