Title: Format error table column
Last modified: November 30, 2023

---

# Format error table column

 *  Resolved [rucar74](https://wordpress.org/support/users/rucar74/)
 * (@rucar74)
 * [2 years, 6 months ago](https://wordpress.org/support/topic/format-error-table-column/)
 * Hi, I need help. As you can see, the “QP” column, unlike “QS” (which have the
   same format), is translated with numbers with a point and not a comma. how can
   I solve it?
 * I would be really grateful
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fformat-error-table-column%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [2 years, 6 months ago](https://wordpress.org/support/topic/format-error-table-column/#post-17244738)
 * Hi!
 * Thanks for your post and sorry for the trouble!
 * Where are these numbers coming from? Are you using math formulas for calculations
   here? Or is this table imported e.g. from an Excel file? Is the format correct
   on the table’s “Edit” screen?
 * Regards,
   Tobias
 *  Thread Starter [rucar74](https://wordpress.org/support/users/rucar74/)
 * (@rucar74)
 * [2 years, 6 months ago](https://wordpress.org/support/topic/format-error-table-column/#post-17247336)
 * Hi thanks for replying to me. They were imported from Excel, the format is the
   same as the other columns, on Excel they are seen with the correct format while
   when I import them into the plugin only the QP column shows the numbers with 
   a period and not a comma 🙁
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [2 years, 6 months ago](https://wordpress.org/support/topic/format-error-table-column/#post-17247881)
 * Hi,
 * thanks for the clarification! It seems like TablePress was unable to properly
   detect the format of these cells in the Excel file then (which can be very complex).
 * I therefore suggest that you try again with a CSV file: Save the file to the 
   CSV format in Excel and import that into TablePress. This should yield the exact
   same formatting that you are seeing in Excel.
 * Best wishes,
   Tobias
 *  Thread Starter [rucar74](https://wordpress.org/support/users/rucar74/)
 * (@rucar74)
 * [2 years, 6 months ago](https://wordpress.org/support/topic/format-error-table-column/#post-17248052)
 * Gentile Tobia,
 * So I extract data from a public Basketball dating site via query, then convert
   it to CSV and finally import it? Ok I’ll try and keep you updated.
 * In the meantime l ask, isn’t it possible to use a specific command via Jquery
   to have the data converted into a certain format?
 * Tank you !
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [2 years, 6 months ago](https://wordpress.org/support/topic/format-error-table-column/#post-17248279)
 * Hi,
 * above, you said that you were importing from Excel, so the easiest would be to
   just use “File” -> “Save as” and then choose the CSV format there.
 * Reformating using jQuery would also be possible, but that would be much more 
   complicated here right now.
 * Regards,
   Tobias

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Format error table column’ 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/)

 * 5 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [2 years, 6 months ago](https://wordpress.org/support/topic/format-error-table-column/#post-17248279)
 * Status: resolved