Importing Currency Column Problem

  • Resolved smartfinds

    (@smartfinds)


    10 years ago

    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://www.ads-software.com/plugins/tablepress/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    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

    (@smartfinds)

    Hi Tobias,

    Thank you for the quick response.

    Importing as a CSV corrected the problem.

    Much appreciated.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    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 here in the plugin directory. Thanks!

    Thread Starter smartfinds

    (@smartfinds)

    Plugin has been rated and favorited.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    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.