View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shatin[_2_] Shatin[_2_] is offline
external usenet poster
 
Posts: 56
Default 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!