in reply to how to format cell as text?
alright guys sorrie let me be more specific
well basically i have a text file .txt file containing information like :
91000000,34526812233930
72788171, 345268812233931
112332332, 34526800812233932
1 rows selected
i got a perl script using win32::OLE
to print all this information into excel sheet
but the problem is the number that are too long are printed out in exponential format like 3.45+E14
i want it to be as it is per normal
in excel i know u can use drop down and change the cell format to text
but any idea how i can automate this in perl script?