How to change the date format from import link?

[Eric]

Does anyone have any suggestions on how to change the date format from import
link? when I import the external link into excel, the some date format will
switch from dd-mm-yy to mm-dd-yy, but some does not.
Does anyone have any suggestions on how to control the date format from
import link?
Thanks in advance for any suggestions
Eric

http://www.hkex.com.hk/eng/prod/drprod/hkifo/tradcalend_1.htm

 

[David Biddulph]

When you are putting data of that type into Excel, you need to make sure
that the order of the date format agrees with what you have specified as the
order in Windows Regional Options (in Control Panel, not in Excel).
Once the data has been recognised as a date (not as text) and stored as a
date in Excel, you can use Excel's "Format Cells" to display the dates in
whichever format you prefer.