David Carter's series of Five Minute Tips aims to develop your skill at using Excel pivot tables. To test these formating tips for yourself, try them out on your copy of the pivot_practice.xls ...

The normal way of formatting cells in Excel (highlight the area, then Format - Cells at the top of the screen) doesn't work for pivot tables. Or rather, it will work once, but as soon as you Refresh ...