Pivot Table - Rounding the numbers in the Data Area

S

Shatin

I know that one way to round a number to the nearest quarter is to use
following formula:
=ROUND(A1/0.25,0)*0.25

How can I round all the numbers in the Data Area of a pivot table to the
nearest 0.25? Do we need to use custom number? If yes, how is that done?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top