For your cell formula, you could use =ROUND(MEDIAN(A1:A10),0)



"David Russell" wrote in message
...
I am generating charts from PivotTable reports. The tables take thier data
from a field that contains a =median() formula. The formula often gives
deicmal results (3.5 for example) and I use cell formating to round the
number to the nearest whole.

Whoever, the PivotTable refuses to use the rounded number and instead uses
the decimal result from the formula. I need the PivotTable to use the
rounded
number and not the decimal number. Has any one had any experience with
this?

Thanks,

David Russell
Software Support Analyst
School District 54