The Surprising Way to Default Pivot Table Formatting

[@Up4Excel]

I’ll show you a work around to get number formats in pivot tables to default to whatever number of decimal places you want using the ROUND formula.

[@JamesMathew2023]

Thanks it worked

[@Up4Excel]

You're welcome!

[@rommelobra434]

how about percentage and also please make a tutorial for return value format

[@Up4Excel]

For a percentage just set the rounding to 2 decimal places extra as 1% percent is 0.01. Return value format tutorials will be coming but not yet I'm afraid. Search Excel custom format tutorial for info from others though👍

[@ramypunjaban2760]

Thank you. However, Do you know how to remove Hidden decimals from a pivot table without loosing formula from my RAW DATA sheet. When I plot pivot chart all 8 decimal values are showing on the chart. I know you have the solution. Thank you in advance.

[@Up4Excel]

Have a look at the tip in this video which should help you to format the numbers on your chart to remove decimals ruclips.net/video/TWqG3X5VbrU/видео.html

[@tmshaheem]

How to avoid decimals in case of average values?

[@Up4Excel]

Simply embed your AVERAGE function inside this ROUND function. That'll do the job 👍

[@iMobileToyz]

Not an efficience way, have to repeat new pivot :(

[@Up4Excel]

You don't need to repeat a new pivot table because you could either change the data range of the existing one or make a copy of the original column and put the formula in your original column pointing at the copy column. That way the pivot table would be picking up the same column but with rounded numbers. Hope that helps explain, thanks for commenting 👍