<div>
1.Select the comple column by clicking on header<br />
2. Right click<br />
3. select Format cells<br />
4. Change Number to Text
</div>


1.Select the comple column by clicking on header
2. Right click
3. select Format cells
4. Change Number to Text

<div>
How do I do this in code/macro? VB6?
</div>


<div>
<div class="content wysiwyg-content">
How do I set the attribute of a column to TEXT? &nbsp;<br />
<br />
I am loading a Excel spread sheet with a .CSV file. <br />
Input<br />
&quot;01&quot;,&quot;KOMA01&quot;,&quot;9090909&quot;<br />
<br />
Excel <br />
<br />
|1 |KOMA01|9090909<br />
<br />
I need to change to first column to text<br />
<br />
|01|KOMA01|9090909<br />
<br />
Thanks,
</div>
</div>


How do I set the attribute of a column to TEXT?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.