Can we customize a number field as a % type field

[AM]

I was wondering if we can customize a number field to use as a % type.
I tried and I could not.
-AM

 

[Jim Aksel]

If you want to key in a value into a number field an have it display as
percent.... I don't think it will do that.

However, you could customize the field and use a formula including a *100.
That won't do much good if your intent is to type in a % value like 5%. My
method will work only if you use the Number field to perform a calculation.

 

[John]

I was wondering if we can customize a number field to use as a % type.
I tried and I could not.
-AM

AM,
If you mean that you want a "%" symbol to appear in a spare number
field, then no, spare number fields in Project can only display fixed or
floating point numbers. To show a numerical value with a "%" symbol, use
a spare text field. There are a couple different ways to show the symbol
but the easiest is probably with the Format function. For example:
Text1=format(3/10,"#.0%")
will give a value of 30.0%

Hope this helps.
John
Project MVP

 

[AM]

That's great!!...but I think I cannot have a different figure for each
row with that...unless I am missing something or just being dumb!

-AM

 

[John]

That's great!!...but I think I cannot have a different figure for each
row with that...unless I am missing something or just being dumb!

-AM

AM,
What do you mean "... a different figure for each row..."? If you have
more than one value per task, use multiple spare text fields, each
customized with its own formula. Or maybe I'm missing something.

John
Project MVP

 

[AM]

John,

I am still a newbie to Project and honestly do not know how to do that.
I would appreciate more help on that one please.

Thanks,
AM

 

[John]

John,

I am still a newbie to Project and honestly do not know how to do that.
I would appreciate more help on that one please.

Thanks,
AM

AM,
OK, let's go back to basics. What exactly do you want to do? That is,
what is your end goal? Let us figure out the best way to do it.

John
Project MVP

 

[AM]

John,

Ok, the end goal is that I need a column that is called Planned %
complete, which would basically let the PMs say - this is what was
planned to finish this week. So I wanted a column where I could let
them enter these numbers and also have the % symbol.
I also need to find the delta between the % complete and the Planned %
complete because that's how I plan to give a status(red,yellow,green),
based on certain rules, to each task.

Let me know if you need more info.

Regards