Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot table irritation
This is causing me a lot of unnecessary work.
Whenever I format cells and do a refresh the formatting reverts back to default. Eg. I format date as Jan-05 when it shows 05/01 to Jan 2005. On entering new data and refreshing it reverts back to 05/01. I have selected keep formatting option in Table Option. Is there something else I have to do to get the formatting I want? Help appreciated and thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table services | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
convert excel list to pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |