concatenate

[Laz]

How can I use a spare text field, to concatenate a number from a formula in a
custom number filed and alpha characters, say a "%" pecent sign?

 

[JulieS]

Hi Laz,

Assuming your number is in the Number1 field. In a spare text field
(Text1 for example) customize the field with the formula:
[Number1] & " %"

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[Laz]

Thanks! this helped.
I used Left([Number1],5) & " %"

Hi Laz,

Assuming your number is in the Number1 field. In a spare text field
(Text1 for example) customize the field with the formula:
[Number1] & " %"

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

How can I use a spare text field, to concatenate a number from a
formula in a
custom number filed and alpha characters, say a "%" pecent sign?

 

[JulieS]

You're welcome and thanks for the feedback.
Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Thanks! this helped.
I used Left([Number1],5) & " %"

Hi Laz,

Assuming your number is in the Number1 field. In a spare text field
(Text1 for example) customize the field with the formula:
[Number1] & " %"

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project

How can I use a spare text field, to concatenate a number from a
formula in a
custom number filed and alpha characters, say a "%" pecent sign?