Currency/Percent Formats

  • Resolved lemorin

    (@lemorin)


    6 years, 11 months ago

    Hi,

    Is it possible to apply certain currency or pervent formats to entire columns or fields etc?

    For example on my csv i have: 133282946.3

    I want it to be displayed in the table as: $133,282,946.30

    Or if I have .10
    I wanted it to be displayed as 10%

    Thank you!!

Viewing 1 replies (of 1 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    6 years, 11 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    Within TablePress, you could achieve this by adding a formula to the table, e.g. the NUMBER_FORMAT() function, see https://tablepress.org/tablepress-features-formulas/

    The better solution however should be to format your columns offline, e.g. in Excel and then save the formatted table to a CSV file, which you can again import into TablePress.

    Regards,
    Tobias

Viewing 1 replies (of 1 total)
  • The topic ‘Currency/Percent Formats’ is closed to new replies.