Decimal places of MS project custom field

[Jhonex1]

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

[#2]

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

[#3]

@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.

[#4 · Accepted solution]

@Jhonex1 

Use this construct for the custom Text4 field:

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

John

[#5]

Works perfectly !!... thank you