Macro copies date into wrong format

Dear experts,

I have a macro to merge txt files under ach other, but it copies the dates into a wrong format.

If it is 23/03/2000 (DD/MM/YY) is stays 23/03/2000 (DD/MM/YY)

But if it is 8/03/2000 (DD/MM/YY) it converts it into 8.3.2000

Is there a way to fix that?

I am using Excel 2011 on a Mac 10.6.8

Please Login or Register  to view this content.

Thanks heaps!!
Stefan