rounding in a pivottable (vba code?)

[ebotman]

Hello,

Does anyone know if it is possible to round numbers to multiples of '000 in a pivottable? Example: 190600 --> 191000

What would the VBA be for this?
Thanks a lot!
Emiel

 

[Andrew Poulsom]

You can't edit cells in a pivot table. But you could use the number format #, to display 191.

 

[ebotman]

thanks for your fast reply. It is not really what I wanted but at least now I know the only option is to alter the sourcedata.
thanks
emiel