Excel thinks my text is in Scientific Notation

[JCtheEUC]

I am importing a txt file into excel. Column B contains # and text. the numbers look like this "4454" the text is like this "95t6" and sometimes "94e7" (these are the ones that excel thinks are scientific notation bc of the "e".). When I copy and paste values into a new sheet it takes the 94e7 and makes it 940000000.

How can I stop this from happening?

 

[kgkev]

Change the cell to text format. FORMAT > CELLS...

or put a ' before

ie

'94e7

 

[JCtheEUC]

Thanks!

Since I'm doing everything automatically I don't really want to go in and set it manaully.

I got it fixed by setting the column to text on the import of the file.

Thanks again!