<div>
Thanks for responding. I currently had it as you have indicated. &nbsp;Unfortunately, at this moment, I have lost my MainForm.vb &nbsp;to:<br />
<br />
&nbsp;Error &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Unable to open module file 'C:\Documents and Settings\...MainForm.vb': System Error &amp;Hc0000006&amp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />
Thanks,<br />
jimbo99999
</div>


Thanks for responding. I currently had it as you have indicated.  Unfortunately, at this moment, I have lost my MainForm.vb  to:

 Error      11      Unable to open module file 'C:\Documents and Settings\...MainForm.vb': System Error &Hc0000006&      

Thanks,
jimbo99999

<div>
Thanks, I have it working now.
</div>


<div>
<div class="content wysiwyg-content">
Good Day Experts!<br />
<br />
I have a bit trouble with exporting my DataGrid to Excel. &nbsp;When I have issue with values like 2.01E+111 in and Excel spreadsheet I just format the column to &quot;Special&quot; and it displays the correct/full value. &nbsp;<br />
<br />
How do I set this column to &quot;Special&quot; programatically so when I export from VB.Net DataGrid I see the full value?<br />
<br />
Thanks for the help,<br />
jimbo99999
</div>
</div>


Good Day Experts!

I have a bit trouble with exporting my DataGrid to Excel.  When I have issue with values like 2.01E+111 in and Excel spreadsheet I just format the column to "Special" and it displays the correct/full value.  

How do I set this column to "Special" programatically so when I export from VB.Net DataGrid I see the full value?

Thanks for the help,
jimbo99999

Vb.Net - Set Excel Column to Special

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,