Thousands and currencies separators displayed

  • Resolved Karel Rehak

    (@rehakk)


    3 years, 1 month ago

    Hi, I need to see the amount in the format 12.345 CZK in the price column. How to do it?
    It is not a problem to display the currency in the sum of the column where the formula is, for example: = {SUM (B2: B44)} CZK .
    But I’m not able to display the thousands separator.

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.

    For this, you can use the NUMBER_FORMAT_EU() function, see https://tablepress.org/tablepress-features-formulas/

    Your formula would then become

    ={NUMBER_FORMAT_EU( SUM(B2:B44), 0 )} CZK

    Regards,
    Tobias

    Thread Starter Karel Rehak

    (@rehakk)

    Great, this is exactly it. I would need the same not only in the sum, but also in the column above the sum.
    Current status
    10456
    14698
    25741
    ———-
    SUM: 50.895 CZK

    but correctly it should be like this:
    10.456 CZK
    14.698 CZK
    25.741 CZK
    ———-
    SUM: 50.895 CZK

    Unfortunately they can’t attach pictures …

    Karel

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    the “trick” here is to split calculation and presentation, as TablePress can only use cells with pure numbers for calculation.
    For this, you could add a second column, directly on the right of your current column with the pure numbers.
    There, you would add the formulas like

    ={NUMBER_FORMAT_EU( B2, 0 )} CZK

    and so on.
    The original column, with just the numbers could then be marked as “hidden” via the button below the table input fields.

    Regards,
    Tobias

    Thread Starter Karel Rehak

    (@rehakk)

    Thanks!

    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 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Thousands and currencies separators displayed’ is closed to new replies.