Hi,
I have try to export it to TEXT column in excel file. But it consists of character the column cannot be exported to text column.My code is as below.

Code:
 Dim strStyle As String = "<style>.text { mso-number-format:\@; } </style>"



 For intTemp As Integer = 1 To ldstCompareResult.Tables(0).Rows.Count - 1
     dgdResult.Items(intTemp).Cells(0).Attributes.Add("class", "text")
 Next

 Response.ClearContent()
 Response.Charset = ""
 Response.Buffer = True
 Response.AddHeader("Content-Disposition", "attachment;filename=" & "ExportedExcel.xls")
 Response.ContentType = "application/vnd.ms-excel"

 Dim style As String
 style = "<style> .text { mso-number-format:\@; } </style> "
 Response.Write(style)
Does anyone has idea on this?