steven
select the pivot table areas you want to align, right click in the pivot table and select 'format cells' from the shortcut menu. select the 'alignment' tab which will show all alignment options, including vertical and horizontal.
Anno,
Thanks for your (quick !)feedback and you're right it does work that way. I have tested with a new pivot table and it worked. The only weird thing is that the p-table I am using does not (?!) react on the "center" instruction (only the header is centered but not the data .....). Very strange. I might need to rebuild my table to get rid of this error (I suppose).
Thanks again
Steven
It could be that you have an option to refresh upon opening, which will always refresh the data...however, if you do not have the selection button depressed, it will renew the formatting each time, appearing to forget your centering
try right click on the pivot and choose "select" then choose "enable selection"..... this should preserve any formatting you carry out (ie centering) when you manually refresh or refresh upon opening the pivot table
HTH
Chris
It could also be the number format chosen. If you selected the "," from the toolbar - it will align it right. Try changing the number format as well.
Thanks guys, you were right, it had to do with the Enable Selection option. The table looks much better now !
Thanks
Steven