Forum Discussion
Jhonex1
Jun 13, 2022Copper Contributor
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
- John-projectSilver ContributorJhonex1,
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- Jhonex1Copper Contributor
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-projectSilver Contributor