0 Replies Latest reply on Aug 28, 2014 8:14 AM by willrollo

    excel export date format

      Title

      excel export date format

      Post

           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....