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]

Xhuey, you can apply a custom number format to the field. Right-click the
field tile to display the PivotTable Field dialog box (the same one you
describe in your post). Click the Number... button and select Custom. The
Type: field should say 0.00%. Change it to 0.000, then OK, OK.

OK?
--
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.

 

[Guest]

Thanks for giving me some hope...

I've tried applying the custom number to the field as you said (0.00% changed to 0.000), but the cell just show the value that divided by 100 with 3 decimal place (eg: 100.00% -> 1.000). Or did i miss out something?...

Thanks again!

Regards,
xhuey

 

[DDM]

You didn't miss out on anything, xhuey. I misread your original post. I now
see that 0.000 is precisely what you do NOT want. What you want is that,
say, 90.6% will be displayed as simply 90.6, without the %. Unfortunately,
the % is what causes 0.906 to display as 90.6%, and there's just no way, so
far as I know (and I'll be delighted to stand corrected) to get around that.

This is what I would recommend to satisfy your reporting requirement: Copy
the pivot table and paste special it to a new worksheet as values. Enter 100
in an empty cell, copy it, select the numbers in your pivot table and paste
special > multiply them by the 100 to get the format you need. It's a clumsy
workaround, but I don't see any better way.
--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

Thanks for giving me some hope...

I've tried applying the custom number to the field as you said (0.00%

changed to 0.000), but the cell just show the value that divided by 100 with
3 decimal place (eg: 100.00% -> 1.000). Or did i miss out something?...