Import the file using the Text Wizard, and in the third pane, indicate
the columns are Text rather than General.




In article ,
Matthew P. <Matthew wrote:

I have a cell displaying 1.03E+15. It appears that Excel rounded the actual
number to the nearest ending zero. 1030604200755582, 1030604200755583,
1030604200755581 all now show up as 103060420075580. I am opening it as a
.csv

Any suggestions?