View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to change the date format from import link?

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/drpr...adcalend_1.htm