Why data F+20-20% become F20% When Exported To Excel

Hi,

My data F+20-20% in Gridview when exported to Excel become F20%.

I have few ways but it is not working.


I have try to make the excel file column to be TEXT format and the coding is as below but fail.The exported result to excel is F20%

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 
     
lsFileName = txtModel.Text.Trim & "-" & txtRev.Text.Trim & "_" & _ 
txtModelTo.Text.Trim & "-" & txtRevTo.Text.Trim & ".xls" 
Response.ClearContent() 
Response.Charset = "" 
Response.Buffer = True 
Response.AddHeader("Content-Disposition", "attachment;filename=" & lsFileName) 
Response.ContentType = "application/vnd.ms-excel" 
Dim style As String 
style = "<style> .text { mso-number-format:\@; } </style> " 
Response.Write(style)

---

I have try to solve it by using sql but fail. The exported result to excel is F20%

Code:

---


select 
' '+ convert(varchar(50),'F+20-20%'  )as  Data1 
FROM TABLE1

---

I have also try as below in sql. but the exported result is ''F20%'

Code:

---


  select
''''+ 'F+20-20%' + ''''
FROM TABLE1

---

F+20-20% is actually description keyed in by user which is cannot be avoided and must be allowed.

Does anyone has idea on why this happen and how to solve it.

Help please!!