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. :)