To Avoid exponential notation for long numbers in excel

<quote>

I had this with list of long numbers, about 14000 entered into one column. I highlighted the column, Data -> Text to Columns -> Fixed length -> Don't create any break lines. Clear any that show up -> Select column data format text -> Finish. Worked like a charm.

</quote>

Source: http://superuser.com/questions/33685/how-can-i-avoid-excel-reformatting-the-scientific-notation-numbers-i-enter