Closed
Date Problem in Excel while exporting to datagridview
Hello,
My requirement is to fetch excel date cloumn values to datagridview. But the problem is while fetching the date values to the datagridview it is displaying string values(i.e, 03-10-2018 is displayed as 43001). How can I resolve this problem?
Thanks & Regards,
Annapurna
Posted: 5 years ago
RPA/RDA Practitioner
RPA/RDA Practitioner
US
Try by applying dateformat on DataGridView columns using c# code.
dataGridView1.Columns[0].DefaultCellStyle.Format = "dd/MM/yyyy";