Pivot Table number format won't save

J

JohnW

Hi,

I have forms which display in PivotTable view. One column is a percentage
of the row total. I have set the number format in the properties sheet to
#0% to take the percentage back from two decimal places to none. This works
fine while the form is still open. If I click save and close the form the
next time I open it the formating is back to two decimal places.

How do I retain the number formating, please?

John
 
Top