Hello Friends..

I am using VB 6.0 to transfer data from *.csv ( comma deliminated excel files ) files from each row there to individual *.xls ( pure Excel files ) files for individual rows in *.csv files.

This works fine and i get output properly as i want. But there is one problem regarding data in one coloumn.

I have a coloumn named Date to be inserted in the resultant Excel file. I am presently sending data as pure String format data as for e.g. "07-16-04".

I get it written there in resultant file but in the format as 7/16/2004.

I want it to be written as 07/16/04 or 07-16-04 as such.

its something regarding the format of the cell..

Could anyone please help me out with this..


Nayan