Excel Forum

onvert dates in a file

lea cohen

Member

Members

Forum Posts: 219

Member Since:
March 10, 2016

Offline

June 21, 2022 - 1:11 pm

Hi,

Attached is a file I receive from the system for a month
It has a problem with the dates
In the same column some of the separating dates are - and the separating part is /
I need everything in the separator - convert to the separator /
And at the moment the date is written like this - 04-22-2022
And the date should be like this - 22/04/2022
I would appreciate help in converting the dates.
Thank you!!
Leah

Riny van Eekelen

Örnsköldsvik, Sweden

Moderator

Members

Trusted Members

Moderators

Power BI

Forum Posts: 440

Member Since:
January 31, 2022

Offline

June 21, 2022 - 3:03 pm

Hi Lea,

I imported the cata via the legacy "From text" option. Split into columns by the comma. Then in the third step, mark each of the columns as Date with the MDY format. Now press Finish and the columns are imported as dates in the format that is set on your system, presumably dd/mm/yyyy.

lea cohen

Member

Members

Forum Posts: 219

Member Since:
March 10, 2016

Offline

June 21, 2022 - 7:45 pm

Thanks for the detailed answer!

Regarding the first step -

I imported the cata via the legacy "From text" option.

Where is this button in Excel?

Riny van Eekelen