Log In
Register
Home
March 10, 2016
Offline
Hi, thanks for the help with the attachment -
Column B has dates of 2 types - one in Hebrew format and one in English format
How do you change the English format to the Hebrew format? Will there be a match with the data in column C??
See Answer
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
I imported to the CSV file (legacy text wizard) and indicated that the second column contained dates in the MDY format and the third in the DMY format. That transformed both columns into valid dates as seen in the attached files.
Important that you don't just open the CSV file in Excel. Then Excel will do some guessing as to how to interpret texts that look like dates.
Is that what you had in mind?
Answers Post
March 10, 2016
Offline
Hi,
I would love to understand why you set the second column to MDY?
After all, the Israeli pattern is - DMY
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
The MDY or DMY setting depends on how the source data looks like. Then Excel knows how to "translate" that to your local date format. Since the dates in the second column look like mm/dd/yyyy you need to use MDY upon import and it will come out as dd/mm/yyyy.
1 Guest(s)
