none
How does one change how negative numbers are displayed in Microsoft Project 2013...how do you display negative numbers with negative sign instead of brakets RRS feed

  • Question

  • How does one change how negative numbers are displayed in Microsoft Project 2013...how do you display negative numbers with negative sign instead of brakets
    Monday, November 11, 2013 1:55 AM

All replies

  • domshar --

    In the Work table, Microsoft Project 2013 shows negative numbers in the Work Variance column using the negative sign.  In the Cost table, however, the software uses the accounting formatting with brackets, and I am not aware of any way to change this formatting.  Remember that this software is not like Microsoft Excel where you can change the formatting of negative numbers.  Therefore, I respectfully recommend that you live with it.  Hope this helps.


    Dale A. Howard [MVP]

    Monday, November 11, 2013 3:13 AM
    Moderator
  • I think Dale's right (as usual :-) ).

    Date formats are governed by the regional settings in Window's control panel. I tried changing negative format there then testing in Project, but no change.

    So it looks like changing negative format isn't possible and only date formats reflect regional settings.


    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

    Monday, November 11, 2013 5:50 AM
    Moderator
  • Hello --

    Here is a trick that may work for you. For any data field that natively displays negative values in parentheses, you could create a corresponding custom number or text field that references the original field; the new custom field will display negative values with negative (-) signs. For example, the 'Cost Variance' field displays negative values in parentheses, but you could create a custom number field that references the original field:

    • Custom Number Field: 'Cost Var'
    • Custom attributes: Formula: [Cost Variance]
    • Calculation for task and group summary rows: Use formula

    If you have several field for which you want to convert the display format, then you will need to repeat this technique for each of them... which can get a bit tedious. Also, if the original field is a cost field, then it natively adds the currency symbol (i.e. '$') and thousands separators... but the new custom field will not. If you use a custom text field, then you could create a sophisticated formula that manipulates the result and adds these elements, but it may not be worth your while.

    Good luck!

    -- tz


    Tony Zink | Vice President, EPMA | http://www.epmainc.com | Blog: http://www.epmablog.com | Training: http://www.epmainstitute.com

    Monday, November 11, 2013 2:53 PM
  • Chiming in on Tony's answer.

    Use the following formula in a custom text field to format the Cost field showing negative values with minus.

    Format([Cost],"Standard")

    Displays as:

    Monday, November 11, 2013 3:35 PM
    Moderator