none
Number Format in My Tasks RRS feed

  • Question

  • I have an enterprise number field that is populated by numbers with 5 digits before the decimal point and one after.

    In project it looks like XXXXX.X which is good for me.

    When I publish to PWA, in My Tasks they appear as XX,XXX (e.g. comma as thousands seperator and not showing anything after the decimal point). Both the comma and the lack of the fractions are NOT good for me.

    Any way to control it?

     

    Thanks,

    Barak

    Sunday, October 9, 2011 7:35 PM

All replies

  • Barak --

    Please let us know exactly what type of field you are using and what formula you are using in this field.  Then perhaps we can help you.  Let us know.


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Monday, October 10, 2011 12:01 AM
    Moderator
  • Hi Dale,

    I am using a task field from a type number. It has no formula - it is configured to manual data entry.

    Forgot to mention this is Server 2010 SP1 + June CU.

    Regards,

    Barak

    Tuesday, October 11, 2011 6:57 AM
  • Barak --

    It is not possible to apply custom number formatting to a custom field that requires manual data entry.  Instead, why don't you use a custom Text field instead?  Then the system will display the numbers exactly as the user enters them.  Hope this helps.


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Tuesday, October 11, 2011 11:51 AM
    Moderator
  • Dale,

    This might be an alternative although not an ideal one. We did that but the client didn't like the sorting being alpha-numeric (12000 comes before 9000) and asked for a numeric sorting.

    Barak

    Sunday, October 16, 2011 6:47 AM
  • You could continue to use the Number field for direct input of the values, as well as for sorting, and use a custom Text field with the following formula to display the desired formatting.

    Format(Number1,"0,000.0")

    This will display every number with at least five digits to the left of the decimal, and exactly one digit to the right, as well as comma separators for thousands.


    Reid McTaggart Partner DeltaBahn LLC
    Monday, October 17, 2011 2:20 PM