Skip to content
ProjectControls.com
Microsoft Project

decimal in ms project

In the Open Standard
Ammar SamadMember for 19 years 2 months
Created
3
3
0
Good day my fellow planner,

How to decrease decimal points in planned % tage which I’ve derived from the formula. the results show about 15 decimal points. Anyone can advice as 2 decimal points is good enough to show planned progress.

thank you
Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Mark Chapman ·
    #1
    Tools - Options and View Tab
    Report
  2. 0
    Darren Kosa ·
    #2
    Hi Ammar,

    I wouldn’t show any decimal points for planned progress… what would .15 of a percent work out to anyway? 20 minutes? If you have to plan down to that much detail then I don’t envy your job!! :o)

    I’m assuming you’re using a number column for the formula. If you are you could try this formula in a spare text field.

    Int([NumberX]*100) & "%"

    Obviously NumberX would need to be changed to match whatever Number Field you used. E.g. Int([Number1]*100) & "%"

    Mark,

    Has the View tab been upgraded for 2k7? In 2k3 it only has the option available for currency.

    Regards,

    Darren
    Report
  3. 0
    Mark Chapman ·
    #3
    Hi Darren,

    Your right - that’s for currency only. I use 2003 too.

    Mark
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?