Formatting Raw Data in Worksheets Created from Pivot Table Data

I have a pivot table that provides counts of associates in specific markets who have not completed a training course.
When you click a numeric value within the table, excel creates a new worksheet listing the associates from the original source data sheet that made up the numeric number.
In the new worksheet, there's a column where the formatting of the values doesn't match how they are formatted in the original source data sheet.
Specifically, they are correctly formatted as X% in the source data sheet. In the new worksheet created off the pivot table, they show as .xxx.
How can we make the values in the new worksheet align to the x% format.