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: 2 years ago
US Bank
US Bank
US
Try by applying dateformat on DataGridView columns using c# code.
dataGridView1.Columns[0].DefaultCellStyle.Format = "dd/MM/yyyy";
Posted: 2 years ago
Staidlogic
Staidlogic
IN
I am new to C#.How can we define the script for the above code?
Thanks & Regards,
Anu