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




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