need to force PT to use formated number
 

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

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

Ahh what wisdom, it works perfectly. Many thanks guru.

"Dave R." wrote:

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