Get KoolPHP UI with 30% OFF!

Export to excel date column is exporting as text should be date

Ketan
Hi,
I have tried to export my grid in excel format and it is not exporting date columns of my grid to correct date format in excel.
for example: I am not able to change format of date column on exported file also i am not able to apply any formulas on date column as it is not date in the sense of excel but text format.
so, anyone can suggest a solution for this issue? so date column will export as date and i can process date column after exporting the excel file.
Many thanks in advance. :)
Posted Aug 11, 2017 Kool