Need to get comma

[bharatkishore]

Dear All,

I have created  a pivot table chart and there some calculations. And i have value like 664,123,406. When i am trying to copy table to excel i am getting the value like 664123406(Without Comma).

Can you please tell me how to get the integer value with comma. I am copying the table to excel.

Regards,

RBK

[Sokkorn]

Hi RBK,

Try to format

     1. Right click on pivot table ==> Properties ==> Number ==> Select <Number> in Number Format Settings

     2. User expression: NUM(SUM(FieldValue),'#,##0.00')

     3. And if above have no luck then the last one is TEXT(NUM(SUM(FieldValue),'#,##0.00'))

Try it and let me know.

Regards,

Sokkorn

[bharatkishore]

Thanks for the reply...I will update you once its completed.

Regards,

RBK