Set number without decimal point when export to excel

[soojungParticipant]

Hello
I made jqxGrid having money column. It shows $415,350 in jqxGrid.
But when I export to excel file, that data changes to $415,350.00.
How can I remove .00 ? I need only $415,350

var df_MagamSearch = [
                ...
		{ name: 'TotAmt', type: 'number' }
];

var MagamSearchSource = {
	dataType: "json",
	mtype: 'GET',
	datafields: df_MagamSearch,
	url: '/Magam/GetMagam'
};

var dataAdapter = new $.jqx.dataAdapter(MagamSearchSource);

$jqxGrid.jqxGrid({
        width: 1000,
	source: dataAdapter,
	columns: [
              ...
             { text: 'Total', datafield: 'TotAmt', pinned: true, cellsformat: "c"}
              ...
             }
        ]
});

[Peter StoevKeymaster]

Hi soojung,

Excel applies formatting to the data, too. Do not forget about that. In the export, we set that a given Grid column represents a Currency column in Excel and that’s it. In other words, there is no solution in this case as the program applies its built-in formatting, too.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[soojungParticipant]

Hi Peter,
Thank you for response.

[Author]

Posts