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?

Using Windows Explorer, rename the text file so that it has a 'txt'
extension. For example, change 'MyFile.csv' to 'MyFile.txt'.
Now when you open it, the Text Import Wizard will appear and you can tell
Excel that the column that has 'exponentials' is really TEXT.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"man_see" wrote:

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?