Excel sorting data incorrectly

Where are you importing the data from, and what are the steps you take to do so? In Power Query in 2010, when you select a column in the Query Editor, there is a dropdown at the top to select the data type for the column.
PQ column type.jpg

THank you, thank kind of helped. Excel treats it as numbers now and I am able to sort it.
However, when I transform it, even though I transform it to decimal number and hope to get some digits after the (.), it still gives me a whole number, and for example where it is a 0.091587 it would give me 91587

How to fix this?