Date format not working when exporting to excel

[orlando_acevedo]

Date is displaying with the correct format on the screen, but when exporting, the column becomes text and the dates are displayed with format yyyy-mm-ddT00:00:00.00.
Is there something special that needs to be done so that it is exported with the correct format?

Thank you.

[paramvir]

Please share a test case or following

1. Version of grid.

2. column.format

3. column cell value data sample.

4. column.dataType

[orlando_acevedo]

Hi. Here is the information:

1. Version 5.1

2. Column.format: "#,###.00"

3. Values are decimal

4. Column.dataType: "float"

Thank you for your help.

Orlando.

[paramvir]

But your original question was about date column. You have to apply date format to date values.

https://paramquery.com/pro/api#option-column-dataType