non-zero in excel

[Goh]

sorry guys my mistake for the previous mail. The 'excel' generation is actually in .csv format. In other words, I use Open xxxxx ..(where xxx is .csv format) then using a string, i pass the string into the file row by row through a loop. This is not the normal excel application whereby i can use the .numberformat ...if thats the case how do i perform the insertion of zero number in front?

[Dnereb]

Answered the question in your previous thread

[leinad31]

the cell should be defined as containing text data type... otherwise if its interpreted as numeric, the leading zero is automatically dropped.

[Goh]

but how do I make use of the .numberformat? I mean the current codes Open and Print and close the file, insert data and close,without using the object like xlapp. etc.?

[Goh]

I realise that if the data has at least alph. the 0 in front will appear..whereas if all numbers , it will disappear.

[Goh]

is there anything i can add in as a alph. but is invisible when input to the cell ?

[Hack]

Excel question moved to Office Development.