import a .csv to Excel

[luvyrpet]

The database that I am using saves reports in .csv format only. One of the columns is credit card account numbers. When I open this report I first have to convert this column to text because what shows there is something like
4.12E+ . I am able to convert this to text but what happens then it takes the very last number and changes it to a zero. So all my account numbers in the report ends with 0. The length is the same. Has anyone heard of such nonsense?
thanks