Pivot Table - Rounding the numbers in the Data Area
 

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!

Pivot Table - Rounding the numbers in the Data Area
 

Try formatting the cell to two decomal places or what ever you like


--
shab620
------------------------------------------------------------------------
shab620's Profile: http://www.excelforum.com/member.php...o&userid=26875
View this thread: http://www.excelforum.com/showthread...hreadid=399963