Hi

I'm downloading grid data to excel document using following code snippet

Response.Clear(
Response.Buffer = Tru
Response.ContentType = "application/vnd.ms-excel
Response.AddHeader("content-disposition", "attachment;filename=CDSInfo.csv"
Response.Charset = "
Me.EnableViewState = Fals
Dim oStringWriter As New System.IO.StringWriter(
Dim oHtmlTextWriter As New System.Web.UI.HtmlTextWriter(oStringWriter
Grid1.RenderControl(oHtmlTextWriter
Response.Write(oStringWriter.ToString()
Response.End(

I'm getting everything OK except one problem. I have one column of varchar type which contains numeric values (00002321,009860 ..).The output result in the excel, this columns is appearing with all the leading zeros trimmed off i.e. 00002321 is displayed in excel as 2321. What should I do to get the original value without any trim i.e. 00002321

Thanks
Aja


---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest Community Website: http://www.dotnetjunkies.com/newsgroups/

Try to put an apostrophe sign ( ' ) in front of these values.

Jay Adil



"ajaykrishna" <ajaykrishna_salugu@-NOSPAM-conseco.com> wrote

the excel, this columns is appearing with all the leading zeros trimmed off
i.e. 00002321 is displayed in excel as 2321. What should I do to get the
original value without any trim i.e. 00002321 ?