Excel Pivot table grouping Row Labels that are Percentages

[preetikandpal]

Hi All,

I am trying to create a Pivot group table for the percentage but the format changes to decimal. Can someone help me how to revert this decimal format to % format? In google sheet it shows as both decimal and % format but in excel it is not giving me option to change it %.

I want to change row label format to

0-10%

10%-20%

20%-30%

Example

Row Labels	Count of Participant ID
0-0.1	17​
0.1-0.2	26​
0.2-0.3	39​
0.3-0.4	65​
0.4-0.5	144​
0.5-0.6	65​
0.6-0.7	24​
0.7-0.8	14​
0.8-0.9	5​
0.9-1	5​
1-1.1	8​
1.1-1.2	2​
1.2-1.3	3​
1.3-1.4	1​
1.4-1.5	2​
1.5-1.6	1​
1.7-1.8	1​
Grand Total	422​

 

[pecoflyer]

Hi please post a sample sheet. Pictures are quite useless to work with. Thx

 

[preetikandpal]

@pecoflyer @vletm Attached is the file for your reference.

 

[vletm]

preetikandpal​

Should Your attached file and Your original writing have some connection?
There were none decimal values.
This is one sample how to solve Your case with Your file.
Usage:
#1 modify data
#2 refresh Pivot table