Can't get currency Display And sorting to work

westjohn1234

I've got a pretty standard USD currency column but sorting doesn't seem to detect that it's a currency. For my particular set of data, when I sort, I get the following:

$6.00
$500.00
$500.00
$50.00
$5.00
$5.00
$5.00
$4,072.66
$10,634,884.55

But Now I got my Particular set of data is

6.00
9.99041E+8
1.230276E+9
1.227894E+9
50.00
5.00
5.00
5.00
4.0E+5
1.0634884E+5

Do I need to enable something specific for type auto-detection?(For displaying currency symbol($) with thousand separators)

And also i include following plug ins in my table..
Type detection: http://datatables.net/plug-ins/type-detection#currency
Sorting: http://datatables.net/plug-ins/sorting#currency

My code :











jQuery.fn.dataTableExt.aTypes.push(
function ( sData ) {
// alert(':::::::::;sData '+sData);

var sValidChars = "0123456789.-";
//alert(':::::::::;sValidChars'+sValidChars);
var Char;

// Check the numeric part
for ( i=1 ; i