Converting imported cell from exponential form

[Katie Mac]

Hello, I'm having trouble when I import data into Excel.
Any data including numbers and the letter "E" automatically appears in
exponential form.
For Example:
96E03 9.60E+04
96E003 9.60E+04
10E18 1.00E+19
10E018 1.00E+19
Is there a formula that can be applied to the cells and copied to make life
easier?


Thank you

 

[Gary''s Student]

When you import the data, tell the Import Wizard that the field is Text.