View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DAustin DAustin is offline
external usenet poster
 
Posts: 5
Default Csv date format problem

Hi there,

I have a macro that opens a csv file with dates (and then copies them into
another file), and although the dates are in dd/mm/yyyy format (and so is my
system), they always get opened as mm/dd/yyyy. This only happens when I run
the macro, not when I do the same thing manually.

I've found a few odd workarounds, but am hoping someone can help me find
something to cater for this that will leave the dates in dd/mm/yyyy!

:-)