excel export date format
When I export a date field in an XSLX file, the date format isn't in the same order that was exported. My mac is set to UK so that format is normally DDMMYYYY but I need to export as MMDDYYYY. The FM layout has the field set in the correct data format but when it arrives into excel it is DDMMYYYY. I don't want to set my mac in a different zone if possible as I know the US format would sort this. I have set the export to 'apply current layout's date formatting to exported data' - i would have thought this would have sorted it but it hasn't....