D
DAustin
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!
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!