DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Col1"));
dt.Columns.Add(new DataColumn("Col2"));
DataRow dr = dt.NewRow();
dr[0] = "Employee Time: ";
dr[1] = "13:58"; //total hours:total minutes
dt.Rows.Add(dr);
GridView gv = new GridView();
gv.DataSource = dt;
gv.DataBind();
Then i am exporting this grid to excel.
In excel it shows me "13:58:00 AM" instead of "13:58"
so I need to change the format of excel column, but i don't know how to
do that..
Regards,
Mansi Shah.
*** Sent via Developersdex
http://www.developersdex.com ***