Thread: Date format not correct when you convert a CSV text file in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scarab
 
Posts: n/a
Default Date format not correct when you convert a CSV text file in Excel
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?
Reply With QuoteReply With Quote