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

Ben Hensel,
Thank you very much for your help. That is exactly what I was looking for. I am not that sharp in Excel programming. I am more used to using Matlab and such. But I understand your code. I am just not unable to make one in Excel myself. Thank you very much. You have been upmost helpful. And I can do the exact same thing for column F and change the number 10 (if necessary).

Edit: But I have just one think to ask. Can you also make an expression to go the other way around?

For this given case:
-0,708
-0,754
-0,793
-0,837
-0,878
-0,919
-0,953
-0,99
-0,000104503 (bad, should be -1,04503)
-0,000107374
-0,000112264
-0,000118111
-0,000122044
-0,000126084