Announcements
No record found.
When I Export some reports to Excel numeric data appears as "TEXT" and I have to convert this to a number, is there any way to avoid this, is there a missing setup or parameter?
Thanks in advance.
Hi
I am in SaaS version. Below answer is for SaaS. I heard this is possible in On-prem through Excel Buffer or similar method (https://www.sauravdhyani.com/2021/07/business-central-14-export-to-excel.html)
I asked this questions before and the only answer I received is 1) I need to add Excel Buffer to report page 2) modify report layout. Hence, I never moved forward with either of them.
Recently Microsoft revealed the plan to add Excel Report layouts to reports. Lets hope this can be used for this purpose.
docs.microsoft.com/.../users-use-excel-design-layouts-reports
Hi, If you are developing with Excel Buffer, you can define the Cell Type when exporting.
Cell type:More details: https://yzhums.com/4180/
Hope this will help.
Thanks.
ZHU
this reports come naturally from analysis views (sales, inventory, purchases) nothing programmed here. Do I really need to change this with some coding?
:(
Unfortunately, seems like this is the only option. But I agree with you that numbers should be number. My suggestion is
1) Submit your idea here (or if you want I can do that) https://experience.dynamics.com/ideas/categories/list/?category=54db8819-83ed-e611-8105-5065f38a3bb1&forum=e288ef32-82ed-e611-8101-5065f38b21f1
2) or I hope one of Microsoft employee here can bring this up to there team ( Marco Mels Andy Sather and ... )
Thanks
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,216 Super User 2026 Season 1
YUN ZHU 1,471 Super User 2026 Season 1
AndrewThomas81 1,369
