<div>
I used the following and it worked:<br />
<br />
m_oExcelWS.Range(&quot;F:F&quot;).Nu<wbr />mberFormat<wbr /> = &quot;@&quot;<br />
<br />
Thanks very much!!!
</div>


I used the following and it worked:

m_oExcelWS.Range("F:F").NumberFormat = "@"

Thanks very much!!!

<div>
<div class="content wysiwyg-content">
I'm using Excel.Application to create a spreadsheet from within an asp page. One of the columns contains 5 character codes which should be treated as text, but sometimes they are numeric and have leading zeros, which Excel removes when the spreadsheet is opened. How do I cast the data type of this column as text so that the zeros will be displayed? 
</div>
</div>


I'm using Excel.Application to create a spreadsheet from within an asp page. One of the columns contains 5 character codes which should be treated as text, but sometimes they are numeric and have leading zeros, which Excel removes when the spreadsheet is opened. How do I cast the data type of this column as text so that the zeros will be displayed? 

Excel.Application casting data types

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.