Title: Sorting and Formatting
Last modified: August 21, 2016

---

# Sorting and Formatting

 *  Resolved [affiliate777](https://wordpress.org/support/users/affiliate777/)
 * (@affiliate777)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/sorting-and-formatting/)
 * I know you’ve answered this question previously, but I can’t seem to get it to
   work. The numbers in my table don’t sort properly. I tried to deactivate other
   plugins and also install the TablePress extension, but that didn’t work. Any 
   thoughts?
 * Also, how do I get the table to left align on the page?
 * Thank you for your help.
 * Table Below:
 * [List of Top MBA Programs](http://www.mbastand.com/selecting-a-school/top-mba-programs-2014/)
 * [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)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/sorting-and-formatting/#post-4578864)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * First, the sorting problem: Other plugins don’t influence this, so you can re-
   activate those. You will however need to install the Sorting Plugins Extension.
   
   Then, add this to the “Custom Commands” textfield on the “Edit” screen of the
   table
 *     ```
       "aoColumnDefs": [ { "sType": "formatted-num", "aTargets": [ 6, 8, 9 ] } ]
       ```
   
 * That will sort the currencies correctly. However, there might still be some problems
   as you have many rows with “N/A” entries or entirely empty cells. Those might
   interfere here, as the sorting algorithm doesn’t know how to treat these 🙁
 * For the alignment: The problem here is your theme. It only has a very small content
   width, so that the table is actually aligned on the left. The theme simply leaves
   a rather big padding on the left. You will need to check if there’s a “Full width”
   page template, or add one, or switch to a different theme.
    (You could use a 
   CSS solution, too, however that’s not really robust and might not work everywhere.
   Just add this to the “Custom CSS” textarea on the “Plugin Options” screen of 
   TablePress:
 *     ```
       #tablepress-3_wrapper {
         margin-left: -260px;
       }
       ```
   
 * )
 * Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Sorting and 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/)

## Tags

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

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