Importing date format FMP 9
I am importing data from excel with a date column. I have custom formatted the excel to match the layout in FMP. In the excel file it is YYMMDD, once imported it is displayed MM/DD/YYYY. Why is it changing? The data that was hand keyed shows the YYMMDD. It is only happening on the import.