I am generating an output xls file using vbscript and the column in xls should be of text data type.
The value I am writing is 07740 which is appearing as 7740 in xls generated.
I need the value as 07740 in the xls column cell.
Using MS Office 2003 and vbscript.
Please suggest a solution to this problem.