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

chandrurec

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.

Lgoo

It works with NumerFormat.

gExcelBuffer.NumberFormat := '0,00';

MKuch

Hi,
What I use is:

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

Regards

chandrurec

Hi MKuch,

Ya got it.

Thank you.

Regards,
chandru.