Good morning all,

I’m using Excel 2007 & have created a pivot table that contains several columns of labels. The first label column contains text data but some subsequent label columns contain only numeric data (except of course for the column title). My question is how can I get excel to retain the specific numeric format I apply to the numeric data label columns on refresh?

I have tried formatting & checking the "preserve format on update box" but the format still reverts to “general”. I have also tried formatting the underlying data but this does not work either.

I need to achieve this without the use of macros, which are disabled for general users here as a matter of security.

Thank you in advance for any solution or help in lifting my PC onto the window ledge….

Mat.