View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech
 
Posts: n/a
Default Date format not correct when you convert a CSV text file in Excel

Have to tried the workaround mentioned in the article, using the Local
argument? I switch my settings to UK and I found that using Local fixed the
problem:

Workbooks.Open Filename:="C:\date.csv", Local:=True

--
Jim
"Scarab" wrote in message
...
| Within my CSV file the date is in the format dd/mm/yyyy, when I convert it
| into Excel 2003 the date appears in the format mm/dd/yyyy.
| I see this problem also appeared in Excel 2002 but the regfix supplied by
| Microsoft Knowledge base KB835718 does not work for Excel 2003.
| Please any suggestions?