Log In
Register
Home
March 10, 2016
Offline
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
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
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.
March 10, 2016
Offline
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?
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
On the Data ribbon, Get Data, Legacy Wizards, From Text as shown in the picture.
March 10, 2016
Offline
I do not have the Legacy option
What to do?
Is it possible to fix the table - with the text command to the columns?
VIP
Trusted Members
December 7, 2016
Offline
Hello,
How to enable the Legacy Wizard in Excel for Microsoft 365.
https://support.microsoft.com/.....4a11bcc2a2
Br,
Anders
1 Guest(s)
