You will need to format the range as text before importing and if it still shows up as 4.9169E+15 then you'll just need to make the column wide enough to hold 16 digits.

BSB