I am using Excel 2007 and noticed that when importing a DBF file the dates are displayed as 11/06/2009 in some rows and 20091117 in other rows.
1) This happens only in Excel 2007 only as we have imported the same DBF file on Excel 2003 and 2013.
2) It looks like there is a clear divide between dates where the day and month can be inverted (US to UK), i.e. 20091117 will be recognised as text whereas 11/06/2009 will be recognised as a date.
Is anyone able to shed some light as to why this is happening?
I looked at UK date locales and regional settings but I may have missed something.
many thanks in advance.