Custom Text Field

[Sebastian Cordoba]

Hi everyone.

In order to add the '%' character to a numeric value, I've created a custom
text field which formula is: CStr([Number1]) + "%".

What I get is a very very long string: 23,2833033710997%, how do I reduce
the lenght to only two decimals: 23,28%

Thnks for your help!

 

[Jan De Messemaeker]

Hi,

Cstr(cint([Number1]*100)/100) & "%"
TH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Sebastian Cordoba]

Thanksssssss!!!!!!

Hi,

Cstr(cint([Number1]*100)/100) & "%"
TH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Hi everyone.

In order to add the '%' character to a numeric value, I've created a
custom
text field which formula is: CStr([Number1]) + "%".

What I get is a very very long string: 23,2833033710997%, how do I reduce
the lenght to only two decimals: 23,28%

Thnks for your help!

 

[Rod Gill]

Or if you want 1 or more decimal places:

Format([Number1],"0.0%")


Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Thanksssssss!!!!!!

Hi,

Cstr(cint([Number1]*100)/100) & "%"
TH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Hi everyone.

In order to add the '%' character to a numeric value, I've created a
custom
text field which formula is: CStr([Number1]) + "%".

What I get is a very very long string: 23,2833033710997%, how do I
reduce
the lenght to only two decimals: 23,28%

Thnks for your help!