Change dot in comma

  • Resolved gadrent

    (@gadrent)


    7 years, 7 months ago

    I have two questions.

    Is it possible to change the dot into a comma?
    So instead 25.00 Euro now 25,00 Euro.

    Second, how to change to two numbers behind the comma.
    Instead 25,0111 now 25,01.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Such a conversion is only possible by using formulas, see https://tablepress.org/tablepress-features-formulas/
    For example, you could use
    ={number_format_eu( C2, 2)} Euro
    (C2 is the cell with the current value, without any unit/text).

    Regards,
    Tobias

    Thread Starter gadrent

    (@gadrent)

    Hi Tobias,

    Thanks for your response.

    But I still have a problem.
    I tried several syntaxes but no result.

    What is wrong?

    [table id=1 ={number_format_eu(C2:C10,2)} /]

    [table id=1 ={number_format_eu( C2, 2)} Euro /]

    [table id=1 =number_format_eu( C2, 2) Euro /]

    Regards,
    Gerard.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    This will not work like that, I’m afraid. What I linked to is a formula that you can use in a table cells.
    Changing all dots to commas with one command is not possible. For that, you should maybe export the table to a CSV file. Then, open that in a text editor and use search/replace to change the dot to a comma, and then re-import the file.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Change dot in comma’ is closed to new replies.