1 Reply Latest reply: May 15, 2014 9:56 AM by Mike Urbonas RSS

    Export to Excel Missing Comma's

    Dave-G _

      Under the Options menu in Monarch 8.02, I have updated the Export & Clipboard xls to 97+ and clicked the format to excel box. Monarch table field properties are showing thousands and decimals. Excel is not formatting for commas or decimals with no cents. Users with only Excel Viewer would like to see the thousands separater and cents. Suggestions?

        • Export to Excel Missing Comma's
          Mike Urbonas

          Dave, this is an Excel limitation not Monarch.  I believe (not certain) you can modify your default Excel workbook template to display thousands separator and cents.

           

          From MS Excel help:  You can create templates for workbooks and worksheets. The default template for workbooks is called Book.xlt. The default template for worksheets is called Sheet.xlt.