tag:blogger.com,1999:blog-3122193036149030463.post588272966734431424..comments2024-03-24T23:18:59.313+05:30Comments on Saurav Dhyani - #MSDynNAV & #MSDyn365bc: NAV 2013 & R2 - Export to Excel ReportSaurav Dhyanihttp://www.blogger.com/profile/15377623733497387092noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3122193036149030463.post-30983822836251856982019-04-04T22:47:29.860+05:302019-04-04T22:47:29.860+05:30Just use - ExcelBuf.AddColumn("Value Entry&qu...Just use - ExcelBuf.AddColumn("Value Entry"."Sales Amount (Actual)",FALSE,'',FALSE,FALSE,False,'#,##0.00',ExcelBuf."Cell Type"::Number);Saurav Dhyanihttps://www.blogger.com/profile/15377623733497387092noreply@blogger.comtag:blogger.com,1999:blog-3122193036149030463.post-34270782644202893022019-03-29T22:05:39.619+05:302019-03-29T22:05:39.619+05:30Hi I am using
ExcelBuf.AddColumn("Value Entr...Hi I am using <br />ExcelBuf.AddColumn("Value Entry"."Sales Amount (Actual)",FALSE,'',FALSE,FALSE,False,'',ExcelBuf."Cell Type"::Number);<br />in Nav2018. Everything works well except I don't get any 1000 separator in my numbers. Is there any way to format the cell type?<br />ThanksAnonymoushttps://www.blogger.com/profile/08006018260179877785noreply@blogger.com