I have a CSV file that I will open (or import) and which has one column that contains serial numbers. The problem is that some of the numbers have this format: 123E567.

Excel promptly converts this text to a number: 1.23E+569. Even if I then change the format of the cell to text, it still keep the text 1.23E+569.

How can I either prevent the original text from being converted to begin with or how can I correct it after the fact?

Best regards,
Ken