How to export datas to excel in 2 decimal places format?

chandrurecchandrurec Member Posts: 560
edited 2014-09-12 in NAV Three Tier
Hi All,

I am having one decimal column and this when exported to excel I need to display it in always 2 decimals.

If anyone knows how to achieve this kindly share. I am using the excel buffer concept for exporting to excel from NAV.

Thanks in advance.

Regards,
chandru.

Comments

  • LgooLgoo Member Posts: 44
    It works with NumerFormat.

    gExcelBuffer.NumberFormat := '0,00';
  • MKuchMKuch Member Posts: 2
    Hi,
    What I use is:

    excelBuffer.AddColumn(FORMAT(intVar), FALSE, '', FALSE, FALSE, FALSE, '0.00');

    Regards
  • chandrurecchandrurec Member Posts: 560
    Hi MKuch,

    Ya got it.

    Thank you.

    Regards,
    chandru.
Sign In or Register to comment.