Title: Importing Currency Column Problem
Last modified: August 22, 2016

---

# Importing Currency Column Problem

 *  Resolved [smartfinds](https://wordpress.org/support/users/smartfinds/)
 * (@smartfinds)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/importing-currency-column-problem/)
 * Hello,
 * We’re still fairly new to using Tablepress and only have 3 tables we have imported
   into our WP website.
 * This time we ran into a problem with an Excel file that has a pricing column,
   formatted as currency, US dollars and only two decimals.
 * The import not only is showing the column as a normal number, but the decimals
   are ranging from 3+.
 * We’ve tried reformatting the column, but not having any luck even on a re-import.
 * Any thoughts as to what we’re doing wrong or what we need to do?
 * Thanks for your help.
 * [https://wordpress.org/plugins/tablepress/](https://wordpress.org/plugins/tablepress/)

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

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/importing-currency-column-problem/#post-5928591)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * The direct Excel import is still experimental and can for example not yet take
   the number format of Excel into account.
    Please try the import again after saving
   the table to a CSV file in Excel.
 * Regards,
    Tobias
 *  Thread Starter [smartfinds](https://wordpress.org/support/users/smartfinds/)
 * (@smartfinds)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/importing-currency-column-problem/#post-5928594)
 * Hi Tobias,
 * Thank you for the quick response.
 * Importing as a CSV corrected the problem.
 * Much appreciated.
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/importing-currency-column-problem/#post-5928599)
 * Hi,
 * no problem, you are very welcome! 🙂 Good to hear that this helped!
 * Best wishes,
    Tobias
 * P.S.: In case you haven’t, please [rate TablePress](https://wordpress.org/support/view/plugin-reviews/tablepress)
   here in the plugin directory. Thanks!
 *  Thread Starter [smartfinds](https://wordpress.org/support/users/smartfinds/)
 * (@smartfinds)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/importing-currency-column-problem/#post-5928601)
 * Plugin has been rated and favorited.
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/importing-currency-column-problem/#post-5928680)
 * Hi,
 * thanks, I really appreciate that!
 * Best wishes,
    Tobias

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

The topic ‘Importing Currency Column Problem’ 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: [11 years, 4 months ago](https://wordpress.org/support/topic/importing-currency-column-problem/#post-5928680)
 * Status: resolved