Skip to content

ArcherPoint Dynamics NAV Developer Digest - vol 107Developer Dude

The NAV community, including the ArcherPoint technical staff—is made up of developers, project managers, and consultants who are constantly communicating, with the common goal of sharing helpful information with one another to help customers be more successful.

As they run into issues and questions, find the answers, and make new discoveries, they post them on blogs, forums, social everyone can benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this community—so we thought, wouldn’t it be great to share this great information with everyone who might not have the time to check out the multitude of resources out there? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV experts and devotees around the world. We hope these insights will benefit you, too.

Report with Export to Excel Functionality not Formatting Numbers Properly

Pandiyan ran into an issue with number formatting in Excel and I wanted to ask if anyone has come across this issue. It’s an issue in a report with export to Excel functionality. The Excel value shows item number in TEXT format vs. numeric. For example, the item no. should be displayed as 12345.10, instead it shows 123+4E. I have tried putting 4 single quotes which I read in some blogs will work, but did not have the desired result. It displays the item no. correctly but adds a leading single quote to it. Does anybody have any idea on how to resolve this? NAV 2015 is the version.

Denise Blaisdell responds:
If you are using an Excel buffer table then you can format the AddColumn like this:

ExcelBuf.AddColumn(AmountDueToPrint,FALSE,'',FALSE,FALSE,FALSE,'#,##0.00',ExcelBuf."Cell Type"::Number);

This number formatting works fine if the item no. is a numeric value. It doesn't work for alpha numeric item numbers.

Comment below if you've had the same issue.

Microsoft Says the Cloud is a Security Game Changer

Tim Rains, Microsoft Director of Security, talks with “The Record” about the latest security threats and the highest ranking ones for their customers, as well as why he believes the cloud ups the security game.

If you want to learn more about new security enhancements in NAV 2016, register for our webinar on September 21st.

Wellness Update

ArcherPoint employee owners recently had a 30-day virtual wellness challenge, where we encouraged, inspired (and perhaps taunted) each other to live healthier and get moving. One very interesting article shared during the challenge is this one by Jeff Haden, revealing the one thing to do before starting an exercise regimen.

Speaking of health, we all know happiness is a key factor in our overall health and outlook on life. In this article, Travis Bradberry highlights (or should I say lowlights?) the 10 Troubling Habits of Chronically Unhappy People.  


If you are interested in NAV development, check out our collection of NAV Development Blogs.

For step-by-step instructions on how to perform specific tasks in Microsoft Dynamics NAV, see our collection of NAV How-To blogs.

If you found this post useful, you might also be interested to read through our archive of the Dynamics NAV Developer Digest.

Blog Tags: 
Read ArcherPoint's Blog Follow us on Twitter Follow us on Facebook Follow us on LinkedIn Link to our RSS feed Watch us on YouTube
Get Help Now