Q:

Descending sort in jquery data table does not work properly

I have created a table using jQuery data table. In a specific column I have a range of numeric values from 32 to 1000 (which has no string value).
For this column, I used following options:

{ title: "Approx.count" ,"sType": "numeric"},

Ascending sort works fine started from 32, but descending sort did not work (it starts from 99 instead of 1000).  
How can I fix this?

A:

Have you tried,
{ title: "Approx.count" ,"sType": "num"},

or you should try html-num if you are using html with numbers.
If you are using datatable version 1.10+ use the following code for sorting numbers using the inbuilt code,
$('#example').dataTable( {
    columnDefs: [
       { type: 'formatted-num', targets: 0 }
    ]
 });

If you are using older version of data table (i.e. version < 1.10) then include the formatted-numbers.js and try the above code. More on DataTable sorting

