Hello Kristy

You saved this column as a string, not as a float, and that's why you're facing this issue.

Sorting for string columns is done alphabetically, not numerrically. You would need to either delete this table and create a new float-type column, or convert this column to a float, but most likely you will need to modify the data in that column afterwards.

Hi again Kristy

Strings allow you to enter literally anything in the cell, but that renders the sorting useless in this case.

You can modify the format in wpDataTables settings, so if you see 15.000,00 (with the point being the thousand, and the comma being the decimal separator), you can change it to 15,000.00. Then, as mentioned in my previous response - you will most likely need to modify the data in that column afterwards since converting the data from string to float is not expected to work flawlessly.