Thank you very much for suggestions
Some worksheet is using the date format dd/mm/yy, therefore I cannot change
the Windows Regional Options for date format into mm/dd/yy.
Do you have any other suggestions?
Thank you very much for any suggestions
Eric

"David Biddulph" wrote:

Set the format in Windows Regional Options (via the Control Panel) to match
your data.
--
David Biddulph

"Eric" wrote in message
...
When I import the data from following link, its date format is mm/dd/yy
instead of dd/mm/yy, therefore, the cell will recognize 03/10/09 to be 3
Oct,
2009 instead of 10 Mar, 2009, however, the recognized error occurs on
03/17/09 for a valid date format. Does anyone have any suggestions how to
retrieve the right date format from importing following link?

http://www.ustreas.gov/offices/domes...te/yield.shtml

Thanks in advance for any suggestions
Eric