Hi,
We generate SSRS GL Trial Balance reports and export them to Excel. Unfortunately, the numbers do not export into Excel as numbers. Is there a solution to this?
Thanks,
Linda
*This post is locked for comments
Thank you so much - we'll try both suggestions!
This issue exists when the cell value within SSRS have be formatted and/or has the potential for a null value.
The simplest fix that works 99% of the time is to make the formulas force a number conversion.
Take the SSRS value and add a =Format(SSRS value * 1.00)
This is in SSRS.
When exported to Excel, it will format to a number correctly.
Unfortunately this is an issue in SSRS.
To overcome this issue; once you are in Excel, mark the columns which should be numeric and replace "," by "," and "." by ".".
Good luck.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
