Sort Data Table does not give expected result

Help
1

I put the “Order” to Ascending and i get this:
image

2

Hi @atomic,

try this

SortedDT =

DT.AsEnumerable().OrderBy(Function (f) CInt(f(“ColumnName”))).ToArray.CopyToDatatable

put your column name instead of “ColumnName” in above code.

3

Hi.
How about changing the expression style on excel?
to number

4

Thank you, it works great!

Why does your solution work but the “Sort Data Table” activity doesnt?