Percentage (%) sign in PivotTable... URGENT!!!

[Guest]

Hi

I am doing some reports using PivotTable format. The value (measure) in the table, i changed it to be viewed as percentage of row of the original value (by right-click at the pivottable > Field Settings... > Option>>> select Show data as: % of row > OK > OK). The report will be displayed as percentage value with the '%' sign.

Is there any method to get rid of the '%' sign, which means the report still be displayed as percentage value, but without the '%' sign?

I try to not include the '%' sign, then the percentage value will be shown as value after divided by 100 (for example, 90.6% -> 0.906). I really need help on this, because the requirement for these reports is not to show the '%' sign for percentage value in the reports

Thank you very much

Regards
xhue

 

[DDM]

Pls see my answer in the worksheet functions group.
--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

Hi!

I am doing some reports using PivotTable format. The value (measure) in

the table, i changed it to be viewed as percentage of row of the original
value (by right-click at the pivottable > Field Settings... > Option>>>
select Show data as: % of row > OK > OK). The report will be displayed as
percentage value with the '%' sign.

Is there any method to get rid of the '%' sign, which means the report

still be displayed as percentage value, but without the '%' sign?

I try to not include the '%' sign, then the percentage value will be shown

as value after divided by 100 (for example, 90.6% -> 0.906). I really need
help on this, because the requirement for these reports is not to show the
'%' sign for percentage value in the reports.