Notifications
Clear all
Topic starter
Hi
The attached file in column A has dates that are rewritten in the United States structure - 7/13/2018
and I need to convert them into an Israeli structure - 13/7/2018
How do you do this?
Thanks
Posted : 10/12/2018 3:54 pm
Hi lea
You can use the Data - Text To Columns option
1) Select Column A
2) Select Data - Text To Columns
3) Select Fixed Width - Next - Next
4) Select Date - MDY and press Finish
Hope this helps.
Sunny
Posted : 10/12/2018 7:07 pm
Hi lea
You can also refer here for a comprehensive post on Excel date and time :
https://www.myonlinetraininghub.com/excel-date-and-time
If you download the PDF file you can see the technique I used above in page 26.
Sunny
Posted : 10/12/2018 8:41 pm
