Thousand Separator in number field

[abhi]

HI,

Does anyone know how to add a thousand separator in a number field? I
want to show total hours as actual hours + remaining hours. I used a
project number field for that. It shows 1650 instead of 1,650. Can any
one help?

Thanks

 

[Dale Howard [MVP]]

abhi --

I hope you are not attempting to calculate Work, which is defined as Actual
Work + Remaining Work. Assuming not, you must use a Text field so that you
can format the number the way you wish. Following is a sample formula that
calculates Work, formats the number with commas, and adds "h" after the
number:

Format(([Actual Work]+[Remaining Work])/60,"#,##0") & "h"

The Format function is a text function and can only be used in a Text field.
Use my formula as an example to create your own formula and format the
number. Hope this helps.

 

[abhi]

Thanks for your help Dale. I will try this.

abhi --

I hope you are not attempting to calculate Work, which is defined as Actual
Work + Remaining Work. Assuming not, you must use a Text field so that you
can format the number the way you wish. Following is a sample formula that
calculates Work, formats the number with commas, and adds "h" after the
number:

Format(([Actual Work]+[Remaining Work])/60,"#,##0") & "h"

The Format function is a text function and can only be used in a Text field.
Use my formula as an example to create your own formula and format the
number. Hope this helps.

HI,

Does anyone know how to add a thousand separator in a number field? I
want to show total hours as actual hours + remaining hours. I used a
project number field for that. It shows 1650 instead of 1,650. Can any
one help?

Thanks