View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Skeniver Skeniver is offline
external usenet poster
 
Posts: 1
Default Dates changing when opening a CSV

Hi there

I am opening a CSV file with a bank account statement details in. Excel is
changing the date for mat for some of the dates (but not all of them). So
01/08/2008 (1 Aug 08) is becoming 08/01/2008 (8 Jan 08), but this only
happens for dates before the 12th of every month. It's really irritating! If
I open the CSV manually, it works fine, but with my macro it changes. I can't
figure out a solution...

PLEASE HELP!

ps. I am using Office 2003.