To remove the scientific notation from excel,
1. When importing data from other application import it as csv or tab separated etc...
2. Ctrl A, copy entire data and paste it in excel first column.
3. In excel 2007, go to 'data' tab and select 'Text to Columns'
4. Select the appropriate delimiter
5. In step 3 select all the columns, you can do this by keeping shift key pressed and scroll to the last column and click on last column.
6. Now select 'column data format' as 'text' and press finish.

Voila!!! all the columns have warning indicating number being converted as text, but who cares as long as the scientific notation is gone.