How to Stop Long Numeric to Scientific Conversion if Transfering data from DataGrid to Excel.

[RSB]

Hi Everyone,
i am using the following code to transfer a DataGrid to Excel File.
Every thing works ok beside the long numerice value like 000012190000000 0
gets converted to 1.219E+11.
how can i disable that conversion?
Thanks for the Help

RSB

public static void DataGridToExcel (DataGrid dgExport, HttpResponse
response){
response.Clear( );
response.Charse t = "";
response.Conten tType = "applicatio n/vnd.ms-excel";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter( stringWrite);
DataGrid dg = new DataGrid();
dg = dgExport;
dg.AllowPaging = false;
dg.AllowSorting = false;
dg.GridLines = GridLines.Both;
dg.HeaderStyle. Font.Bold = true;
dg.DataBind();
dg.RenderContro l(htmlWrite);
response.Write( stringWrite.ToS tring());
response.End();
}

[David Jessee]

Well, its not converting....i ts just a formatting issue. I don't know what
your class is doing as far as exporting the data, so I can't tell you
exactly how to do it. But approach it as a formatting issue
"RSB" <rs*****@hotmai l.com> wrote in message
news:yS******** ********@news.c pqcorp.net...

Hi Everyone,
i am using the following code to transfer a DataGrid to Excel File.
Every thing works ok beside the long numerice value like 000012190000000 0
gets converted to 1.219E+11.
how can i disable that conversion?
Thanks for the Help

RSB

public static void DataGridToExcel (DataGrid dgExport, HttpResponse
response){
response.Clear( );
response.Charse t = "";
response.Conten tType = "applicatio n/vnd.ms-excel";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter( stringWrite);
DataGrid dg = new DataGrid();
dg = dgExport;
dg.AllowPaging = false;
dg.AllowSorting = false;
dg.GridLines = GridLines.Both;
dg.HeaderStyle. Font.Bold = true;
dg.DataBind();
dg.RenderContro l(htmlWrite);
response.Write( stringWrite.ToS tring());
response.End();
}