Issues while formating decimal values in export

[vijay@spinetechnologies]

Hi Paramvir,

We have a pqGrid with some decimal columns. We applied format to decimal columns as "##,###.00".

If the cell value is zero, then in excel export cell shows .00 instead of 0.00.

You can find the same case in the given URL: https://paramquery.com/pro/demos87/export
Just need to update the Freight value as Zero for any cell and then export it to Excel.

Also, find an attached PDF for your reference

[paramvir]

Please use "##,##0.00" instead of "##,###.00"

[vijay@spinetechnologies]

Thanks for your reply. Now showing in the proper format