Title: Numberformat
Last modified: August 22, 2016

---

# Numberformat

 *  Resolved [Philhippos](https://wordpress.org/support/users/philhippos/)
 * (@philhippos)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/numberformat/)
 * What numberformat does TablePress expect?
 * If i use the german format for numbers (dot for thousands, comma for decimals)
   the table starts sorting wrong. F.ex.: 12.345,67
 * But also if i use the english format (just the other way around: comma for thousands,
   dot for decimals) the table won’t sort right. F.ex.: 12,345.67
 * The only way i found is not to show the thousands and use the dot for decimals:
   12345,67
 * But that gets a bit unhandy once the numers grow.
    F.ex.: 12456789,12 is less
   readable than 12.456.789,12
 * Thanks for any hints in advance,
    Phil
 * [https://wordpress.org/plugins/tablepress/](https://wordpress.org/plugins/tablepress/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/numberformat/#post-5234703)
 * Hi Phil,
 * thanks for your post, and sorry for the trouble, as well as for the late answer.
   As I was on vacation, I didn’t have a chance to reply earlier.
 * Number formats can indeed be tricky, and by default, the sorting algorithm will
   only recognize “12345.67”. To use other formats, you will need to install extra
   algorithms, for that, please see this TablePress Extension: [http://tablepress.org/extensions/datatables-sorting-plugins/](http://tablepress.org/extensions/datatables-sorting-plugins/)
 * Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Numberformat’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

## Tags

 * [format](https://wordpress.org/support/topic-tag/format/)
 * [number](https://wordpress.org/support/topic-tag/number/)

 * 1 reply
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [11 years, 9 months ago](https://wordpress.org/support/topic/numberformat/#post-5234703)
 * Status: resolved