Importing Text File with Numbers beginning with the letter E

[Cas1]

Can anybody explain why when Importing a Text File with Numbers beginning with the letter E for example E106, Excel then converts this number to an exponential figure? How can this be stopped? What do I need to do in order that the imported text file keeps the number E106?

Thanks in anticipation

 

[Greg Truby]

Choose Text as the column type. Note that if this is a CSV extensioned file, you won't be given the wizard so you can't pick. Change the file's extension to TXT and you'll get the wizard and a chance to configure column types.

 

[Cas1]

Thank you so much for that!