<div>
Do <br />
<br />
<a href="http://support.microsoft.com/kb/81518" rel="ugc">http://support.microsoft.com/kb/81518</a><br />
<a href="http://www.netomatix.com/development/gridviewcustomdataformatting.aspx" rel="ugc">http://www.netomatix.com/development/gridviewcustomdataformatting.aspx</a><br />
<br />
help?
</div>


Do

http://support.microsoft.com/kb/81518 [http://support.microsoft.com/kb/81518]
http://www.netomatix.com/development/gridviewcustomdataformatting.aspx [http://www.netomatix.com/development/gridviewcustomdataformatting.aspx]

help?

<div>
Please notice this<br />
<br />
<a href="http://geekswithblogs.net/ensoftBlog/archive/2005/10/26/58232.aspx" rel="ugc">http://geekswithblogs.net/ensoftBlog/archive/2005/10/26/58232.aspx</a>
</div>


Please notice this

http://geekswithblogs.net/ensoftBlog/archive/2005/10/26/58232.aspx [http://geekswithblogs.net/ensoftBlog/archive/2005/10/26/58232.aspx]

<div>
I fixed it like this-&gt;In Page_PrerenderComplete i have<br />
<br />
&nbsp;oRow.Cells(2).Text = &quot;&amp;nbsp;&quot; &amp;&nbsp;oRow.Cells(2).Text<br />
<br />
The problem was when generating the excel 05 was displayed as 5 in the excel sheet not in the gridview . gridview was fine.<br />
So appended a space there and now it displays 05 as 05 and 5 as 5.
</div>


I fixed it like this->In Page_PrerenderComplete i have

 oRow.Cells(2).Text = "&nbsp;" & oRow.Cells(2).Text

The problem was when generating the excel 05 was displayed as 5 in the excel sheet not in the gridview . gridview was fine.
So appended a space there and now it displays 05 as 05 and 5 as 5.

<div>
Great...<br />
<br />
You can ask for a refund here: <a href="https://www.experts-exchange.com/Community_Support/General/" rel="ugc nofollow">https://www.experts-exchange.com/Community_Support/General/</a>
</div>


Great...

You can ask for a refund here: https://www.experts-exchange.com/Community_Support/General/ [https://www.experts-exchange.com/Community_Support/General/]

<div>
<div class="content wysiwyg-content">
I am generating an excel report from the GridView results.<br />
Their is a column like size and it may have a leading zero like '05'<br />
Excel is formatting 05 as a number and displaying it as 5 .<br />
<br />
How to retain the leading zero.<br />
<br />
<br />

</div>
</div>


I am generating an excel report from the GridView results.
Their is a column like size and it may have a leading zero like '05'
Excel is formatting 05 as a number and displaying it as 5 .

How to retain the leading zero.




generating Excel report from GridView results  in ASP.Net 2.0

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications