Question
2
Replies
79
Views
Posted: January 25, 2019
Last activity: January 28, 2019
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
@AnuP3667
Try by applying dateformat on DataGridView columns using c# code.
dataGridView1.Columns[0].DefaultCellStyle.Format = "dd/MM/yyyy";