Excel changing syntax after using "text to columns" function (URGENT)

Hi,
I have a column which should contain numbers of same order of magnitude. The values you see that I have pasted in, is straight out of my Excel sheet, where the problem initiates. The first 7 values are good and look as expected. But then suddenly it goes to 10^7 instead of being in one-point-something/zero-point-something. If it wasn't because of the fact that it also switches to lower values sometimes (see "very bad") then I would be able to just multiply by 10^-7. But because of this, i cannot. I should mention manually fixing it is impossible. I have this problem in 8 sheets, with more than 1000 numbers in each. Also in three sheets with more than 7000 numbers. The values come from a datalogger at my university which I have been used to testing.
I hope you understand my problem and can help me solve it. I use both Office 2010 and 2013.

0.98214339 (good)
0.98495423 (good)
0.98770445 (good)
0.9905972 (good)
0.99338463 (good)
0.99616996 (good)
0.99907549 (good)
10.018.161
10.046.343
10.074.505
10.103.401
10.131.392
10.159.192
10.186.694
1.021.576 (VERY BAD)
10.243.581
10.271.509

Kind Regards
Ahmad