LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date format problems after csv import YY san.[_2_] Excel Worksheet Functions 1 February 10th 10 11:36 PM
change date format dd/mm/yyyy to Julian date format? itzy bitzy Excel Worksheet Functions 1 December 8th 09 07:42 PM
How do you change format on Excel .CSV file to import to access Matt Excel Discussion (Misc queries) 1 January 17th 07 11:04 PM
Use date modified to change format & create filter to track change PAR Excel Worksheet Functions 0 November 15th 06 09:17 PM
Cell format with Data Import (date appearing as text) Louise Excel Discussion (Misc queries) 3 September 21st 06 01:57 PM


All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"