Tablesorter, sorting numeric data as text

Tablesorter, sorting numeric data as text

Hi,

I'm having problems sorting with tablesorter. My data is percentage scores with 1 decimal place. This works fine on most occassions, but if a figure is less than 10% or 100%, they get sorted as text.

Eg:
my data gets sorted in the following order:
100.0
42.7
54.9
6.3
74.8
8.7
94.2

when it should be sorted as:
6.3
8.7
42.7
54.9
74.8
94.2
100.0

Is there any way I can force the column to be treated as a number?

Thanks


   




























    • Topic Participants

    • craig