Using writeline to write string with leading 0's to excel worksheet columns?

[Rashar]

Hi, Consider the following line, oWrite.WriteLine(strItem & vbTab & partNo) The variable partNo is a string that pulls in a number as such, 00001567842. I am using the writeline method to send that string to an excel sheet. I need to have the values in strItem in column 1, and the values of partNo in column 2 including the leading zeros. I have tried the {1,11}, partNo format or Format("###########", partNo). I have tried declairing partNo as a String as well as an Integer, but neither data types work. I tried to create a csv file, and it does include the leading 0's but when I use vtab, I get the values of strItem, plus a square (which I assume is the vtab), then my partNo all in one cell. Is it possible to accomplish what I want with just the WriteLine method? Thanks in advance.

[ne0h]

Change the Cell's property to Text. I think you need to create an object of Microsoft.Office.Interop.Excel.Style then use NuberFormat property. Just Google it. By default Excel cells are Number type.

-------------------------------- txtSignature