Pivot Table Drill Down - Number Formatting Changes

[redsheep79]

I have a Pivot Table with cells in number format however when I drill down the new sheet that is created defaults to date/time rather than number. Can I change the default so when it drills down the info is in number format?

I know I can change the default table style but cant change the number format only the style format doing this.

Thank you.

[redsheep79]

Think I've got a work around tho not sure if this messes anything up...

Created a new workbook and amended Cell style: Cell Styles > right Click on normal > Modify > Change format to required format.

then go to original workbook with pivot table: Cell styles > Merge styles > select new workbook (above) and Merge styles. Seems to do the job.