data imported into EXCEL as text displayed as exponential number

I

Irv Whalley

I am importing a file which I can define (in the exporting application) as either .txt or .cs

One of the fields on the file contains a telephone number(eg 411618720426) , which in some cases is displayed as an exponential number (eg 4.11619E+11). I want the field as text. Other fields in the same column contain spaces and hyphens. These are treated correctly

I also want the process to be automatic without having to manipulate the first field etc
 
Top