You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Export PBCS Reporting Web Studio report to Excel with numeric formatting instead of text

edited Jan 29, 2019 3:37PM in Planning 5 comments

Summary

Export PBCS Reporting Web Studio report to Excel with numeric formatting instead of text

Content

Whenever we open a PBCS Reporting Web Studio report in Excel all the numbers are in text, which means we can't sum rows.  Currently, we have to highlight any column we want to sum and do "Text to Columns" to fix the formatting.  This becomes a little cumbersome when we have numerous columns to fix each time we run the report to Excel.  Within the report I have values set to numeric but it still doesn't help the issue.  Any ideas on how to fix?  Thanks, John

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!