exchange "," for "." value

Gea

On DataTable, "1,000" is equal to one thousand.
I want to use the "." like the ",".
Example: 1.000 is one thousand.
I'm using the "," for decimals.
if i order my column of numbers, this is what i see:
10.000
9.400
9.000
8,30 <--- this is the problem
5.211
etc

how can i do?
Thanks
Gea.

bcrouzy

Maybe this plugin could help you :
https://www.datatables.net/plug-ins/sorting/formatted-numbers

Gea

Thanks! work it!

allan

There is actually a built in option for this - see the internationalisation section of the manual.

Allan