I am opening a text file using Excel.The text file has data 16E102,which
appears as 1.60E+103 in the excel sheet since it takes the data type as
scientific by default.
However i want it to appear as 16E102 itself.What can be done for this?
Changing the cell format to text does not help,because it keeps the data
already present in it as it is,it will help only if new data is entered in
the similar manner.
Is there any way to set the default column type as text?