How do I format a cell with coma (,)?

  • Resolved webuser1

    (@webuser1)


    4 years, 9 months ago

    Greetings sir,

    Your plugin seems to work well. Thank you very much.

    Initially, I was unable to get the TablePress plugin to display on the web till I found your article about using a shortcode extension and then replave [table id-N] with [tp_table id-N].

    This seems to have done the trick for us.

    However, when we import an excel file with numbers or currency in a few of the columns and fully formatted to display a number with coma (for instance 62,899), these commas disappear when imported and displayed.

    Is a work around to this?

    Thanks again.

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

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    For this, please try to export the table to a CSV file and import that into TablePress. This should preserve the format. The .xlsx format only exports the numbers, without any thousands separators.

    Regards,
    Tobias

    Thread Starter webuser1

    (@webuser1)

    Thank you very much sir.

    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!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How do I format a cell with coma (,)?’ is closed to new replies.