WordPress.org

Forums

TablePress
[resolved] Limit to Number length in Cells (2 posts)

  1. richardr
    Member
    Posted 1 year ago #

    Hi Tobias

    I am just wondering whether there is any shortcode to limit the length of a number after the decimal point.

    I am doing a calculation in a table =D2/C2 and it brings a result 0.0178571428571, so I would like limit it to 3 numbers after the decimal point.

    Thanks
    Richard

    https://wordpress.org/plugins/tablepress/

  2. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    thanks for your post, and sorry for the trouble.

    This can not be done with a Shortcode, but with a math function. For a full list, see http://tablepress.org/tablepress-features-formulas/
    You will then want to use

    =NUMBER_FORMAT(D2/C2, 3)

    Regards,
    Tobias

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • TablePress
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic