2 Replies Latest reply: May 15, 2014 10:01 AM by Sam Chambers RSS

    Zeros Export to Excel as Text

    Sam Chambers

      When I export from Table view to Excel, the zero values that show up in Monarch are coming into Excel as labels.  In the report I'm using, these are actually blank fields. 

       

      "Empty Cells" is set to "Leave blank".  I've verified that the field is formatted correctly in Monarch (V9.01) as numeric, and it shows a zero in the table view.  But when I open the exported file in Excel 2003, those cells display the following message: "The number in this cell is formatted as text or preceded by an apostrophe."

       

      There are far too many of these to fix manually.  What's causing this, and how can I fix it?

       

      Thanks,

       

      Sam.