long numbers changing in .csv file when file is opened

[philip121]

I have a problem that is driving me crazy...

I have a .csv file that I exported from a sql database. One of the columns contains customer account numbers. Most of which are 16 digits long. Some are shorter.
The majority of the account numbers follow this format.
1200000000000167

The problem is that once I open the .csv file in Excel. The account numbers change to something like this.
[TABLE="width: 133"]
<tbody>[TR]
[TD="width: 133, align: right"]1.2E+15[/TD]
[/TR]
</tbody>[/TABLE]

I've tried all kinds of formats and none of them seem to work properly.
I am able to change it to a 16 digit number. But, the number isn't correct, it changes the number. It turns out like this.
1200000000000060

Any assistance would be greatly appreciated.
Thanks,

[TABLE="width: 147"]
<tbody>[TR]
[TD="class: xl65, width: 147, align: right"]Philip
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Ragnar1211]

Use the Data import > From Text feature rather than directly opening the CSV file.

You may want to treat that column as Text rather than a Numeric since it is so long, I assume you don't need to do math with it.