string format getting changed in excel

string StrDat开发者_如何学Pythone= Convert.ToDateTime(Datset.Tables[0].Rows[i][j]).ToString(@"dd-MM-yyyy").Trim(); string StrDateNew=StrDate.ToString(); strmWriteText.Write(StrDateNew.ToString());

when i write the data to excel file the string format is getting chaged into dd/mm/yyyy

is there any way i can solve this problem i am using excel 2000,vs 2003

any help would great thanks

---

you need to deal with the Range.NumberFormat property while you write the data to Excel. e.g. the following line where format myWorkSheet column 1 to "dd-MM-yyyy":

myWorkSheet.get_Range(myWorkSheet.Cells[1,1],myWorkSheet.Cells[Datset.Tables[0].Rows.Count+1,1]).NumberFormat="dd-mm-yyyy";