Forum Discussion

Jhonex1's avatar
Jhonex1
Copper Contributor
Jun 13, 2022

Decimal places of MS project custom field

i,


Hi,
I am new to MS project, I am preparing the project report with the planned percentage of completion. Since this column has the formula to convert number into percentage, it is giving long digit number. I want to know how to bring the number of decimal places to 0 or 0.0%. please find attached screen shot.

Thank you in advance for helping.Custom (text) field decimal places

  • Jhonex1 

    Use this construct for the custom Text4 field:

    Text4=format([Number3],"##.#") & " %"

    John

  • John-project's avatar
    John-project
    Silver Contributor
    Jhonex1,
    Use the Format statement in your custom field formula. For example,
    Format([Text4],"##.#") will give rounded value with one decimal place.

    Hope this helps.
    John
    • Jhonex1's avatar
      Jhonex1
      Copper Contributor

      John-project 

      my custom field have the formula and I am not sure where to add. I am quite new to MS project. Please see the image and guide me accordingly.

       

      • John-project's avatar
        John-project
        Silver Contributor

        Jhonex1 

        Use this construct for the custom Text4 field:

        Text4=format([Number3],"##.#") & " %"

        John

Resources