1

number formatting: negative numbers in parentheses

In Excel, it is standard for us to represent negative numbers such as -123456 in the form (123,456), i.e., negative numbers are printed in parentheses, and there is a comma every three digits. Please add this formatting option in Tabulate.

2 replies

null
    • Customer Solutions Architect
    • Moshe_Yossef
    • 11 mths ago
    • Official response
    • Reported - view

    Hi,

    already exists:
    Here is a tabulate sheet with negative values:

     

    Now I will select the column with negative values, and open the formatting panel:

    next I will replace general with custom, and select the desired format:

    You can also type the format in just remember to hit enter at the end.

    regards,

    • Senior Director of Product
    • Ian_Macdonald
    • 11 mths ago
    • Reported - view

    Hi Mathias,

    This feature was introduced in Pyramid 2023.10 in December 2023. You may need to upgrade your installation to see this functionality.

    Regards,

    Ian

Content aside

  • Status Answered
  • 1 Likes
  • 11 mths agoLast active
  • 2Replies
  • 880Views
  • 3 Following