<div>
You can do it this way<br />
<br />
&nbsp; &nbsp; ' To number<br />
&nbsp; &nbsp; YourWorkCell.NumberFormat = &quot;@&quot;<br />
&nbsp; &nbsp; ' To Date<br />
&nbsp; &nbsp; YourWorkCell.NumberFormat = &quot;m/d/yyyy&quot;
</div>


You can do it this way

    ' To number
    YourWorkCell.NumberFormat = "@"
    ' To Date
    YourWorkCell.NumberFormat = "m/d/yyyy"

<div>
I need more of the text format because I have an account number that is preceeded with zeros, so not to let excel strip the zeros I need to format the column as text.<br />
<br />
Thanks
</div>


I need more of the text format because I have an account number that is preceeded with zeros, so not to let excel strip the zeros I need to format the column as text.

Thanks

<div>
<div class="content wysiwyg-content">
vb .net 2003. &nbsp;When calling an excel application and writing data to the workseet. &nbsp;How do you format a column to text or date or general?
</div>
</div>


vb .net 2003.  When calling an excel application and writing data to the workseet.  How do you format a column to text or date or general?

vb .net 2003 open excel app and format a column to a text or date type

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,