How to format percentage column as a number format

[acsishere]

Dear Friends,

Best wishes!!!

In a pivot table a percentage column is added which calculates the percentage automatically. The percentage column shows the value with "%" (Ex. 54.12%). I tried different possibilities, but in vain.

How to avoid / re-format this to show only the value (i.e. I need only the value 54.12 - instead of 54.12%)

Thanks in advance,

acsishere.

[darkyam]

Multiply by 100 and format as a number.

[acsishere]

Thanks for your reply. I tried with your solution and still it is the problem.

I attached a sample file for your kind refernce.

Thanks in advance.

acsishere.

[darkyam]

Perhaps this will work. I am not too familiar with pivot tables, so I took the last column off the table and used a calculation and then formatted appropriately.

[oldchippy]

Take a look at this link on putting a calculated field in a pivot table

http://www.datapigtechnologies.com/ExcelMain.htm