Question 2 Replies 143 Views × Close popover Mandaris Moore (Mandaris) State of California - Franchise Tax Board State of California - Franchise Tax Board US View Profile Send Message Mandaris Member since 2019 9 posts State of California - Franchise Tax Board Posted: October 8, 2019 Last activity: October 11, 2019 Posted: 8 Oct 2019 13:35 EDT Last activity: 11 Oct 2019 13:46 EDT Closed Reports exported to excel have numbers with extra zeros (0) We're running 8.1.3 and have a series of reports that work fine when viewing it in the report viewer. Unfortunately, when we export these to excel. The values are inconsistent and don't work well with formulas. We don't want to change all the values manually and we've already attempted editing the properties for the columns. ***Edited by Moderator Marissa to update platform capability tags**** Reporting × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 1 year ago Posted: 9 Oct 2019 12:07 EDT × Close popover John Pritchard-Williams (JOHNPW_GCS) PEGA Client Support Team Lead Pegasystems Inc. GB View Profile Send Message JOHNPW_GCS PEGA replied to Mandaris Hi Mandaris, Would you say that this appears to be a formatting issue - rather than a data issue? That is: to fix this - are you using the EXCEL function "Format Cells > Number > Number > Decimal Places" on the whole sheet and re-saving it - or do you have actually edit the cells themselves? It might help if you could: - Upload an example EXCEL file here - Confirm (with screenshots if possible) the exact steps you went through to generate the report. (Presumably - you just ran a Pega Report - previewing it - and then did "Export To Excel"? - but should wanted to make sure). I have uploaded a manually-created Excel file here - just to show what I mean by the formatting: I haven't tried 'Export To Excel' in 8.1.3 yet to see what happens. Posted: 1 year ago Posted: 11 Oct 2019 13:46 EDT × Close popover Mandaris Moore (Mandaris) State of California - Franchise Tax Board State of California - Franchise Tax Board US View Profile Send Message Mandaris State of California - Franchise Tax Board replied to Mandaris Thank you John, I've attached a scrubbed copy of the excel exported from PEGA. The key columns are Y - AC. These are some screenshots of the steps that I'm doing. Running the report. Setting the filters (just to reduce the amount of results). Finally, exporting to excel. I suspect it has something to do with the fact that the values are stored as doubles and PEGA doesn't do formatting for doubles that are exported to excel.