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 set the cell for date?

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