1 Reply Latest reply: May 15, 2014 10:03 AM by Data Kruncher RSS

    Exporting Date to Excel

    chuck.kennedy _

      When I export a Date field in Monarch to excel, it shows up in excel as a text field.  I have to convert it in excel.

       

      What can I do in Monarch to have it export it to excel as a date?

       

      THe format of the data is mm/dd/yy..

       

      Thanks

      Chuck

        • Exporting Date to Excel
          Data Kruncher

          Hi Chuck,

           

          Excel export styles are controlled via the settings in the Options , Exports and Clipboard menu.

           

          Be sure to XLS drop-down to Excel 97+ (Monarch V9) and /Bcheck the Apply formatting to Excel files (XLS and XLSX) box.

           

          That should resolve the problem.

           

          Kruncher