Title: tabel problems: sorting, formatting
Last modified: May 17, 2022

---

# tabel problems: sorting, formatting

 *  Resolved [keesjan](https://wordpress.org/support/users/keesjan/)
 * (@keesjan)
 * [4 years ago](https://wordpress.org/support/topic/tabel-problems-sorting-formatting/)
 * Hi Tobias,
    I importeed this excel table with 2 digit rounds to tablepress and
   published it. – As you can see the numbers are not rounded. – Sorting is not 
   working Has this to do with . or , numbers?
 * What would yu suggest?
    I found =number_format_eu(x,d) as formule.
 * Is there an easy way to change a column or is this copy past and change cell 
   hell?
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ftabel-problems-sorting-formatting%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [4 years ago](https://wordpress.org/support/topic/tabel-problems-sorting-formatting/#post-15654116)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * Please try saving the table to the CSV format in Excel, and import that. That
   should import the numbers as desired, so that you should not need any formulas
   or other changes.
 * Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘tabel problems: sorting, formatting’ 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/)

 * 1 reply
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [4 years ago](https://wordpress.org/support/topic/tabel-problems-sorting-formatting/#post-15654116)
 * Status: resolved