MSFlexGrid1.Sort = flexSortGenericAscending

Why does sorting numbers work then not work, results seem very unpredictable when the column data is decimal numbers similar to this

45.78
56.78
33.67
33.56
32.67

Is it because the flexgrid is text

Do you have to sort the recordset and then repopulate the grid