<div>
That sounds like what I need. &nbsp;What I'm trying to find out though is how to attach that formatting to my gridview cell. &nbsp;Any ideas on that?
</div>


That sounds like what I need.  What I'm trying to find out though is how to attach that formatting to my gridview cell.  Any ideas on that?

<div>
I found it!<br />
<br />
<a href="http://geekswithblogs.net/AzamSharp/archive/2006/08/12/87804.aspx" rel="ugc">http://geekswithblogs.net/AzamSharp/archive/2006/08/12/87804.aspx</a><br />
<br />
needo_jee, you gave me the correct idea to search and this article further explains how to use it with a gridview like I needed. &nbsp;Thanks for your help!
</div>


I found it!

http://geekswithblogs.net/AzamSharp/archive/2006/08/12/87804.aspx [http://geekswithblogs.net/AzamSharp/archive/2006/08/12/87804.aspx]

needo_jee, you gave me the correct idea to search and this article further explains how to use it with a gridview like I needed.  Thanks for your help!

<div>
<div class="content wysiwyg-content">
I am trying to export a gridview to excel with the same formatting that is in my gridview but my formatting is stripped out on the export.<br />
<br />
I am loading a gridview with ObjectDataSource. &nbsp;In the ObjectDataSource I load the data into a dataset with some custom string formating like this:<br />
<br />
GridViewField = string.Format(&quot;{0:0000000}<wbr />.{1:00}&quot;, numberOne, numberTwo);<br />
<br />
It works fine when I view my gridview in the web browser but when I export to excel the numbers are not with this formatting. &nbsp;How can I force the formatting to be the same for the export to excel? &nbsp;
</div>
</div>


I am trying to export a gridview to excel with the same formatting that is in my gridview but my formatting is stripped out on the export.

I am loading a gridview with ObjectDataSource.  In the ObjectDataSource I load the data into a dataset with some custom string formating like this:

GridViewField = string.Format("{0:0000000}.{1:00}", numberOne, numberTwo);

It works fine when I view my gridview in the web browser but when I export to excel the numbers are not with this formatting.  How can I force the formatting to be the same for the export to excel?  

Gridview number format disappears on export to excel

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

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

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