Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table formatting
I have created a pivot table which includes a column showing times. The data
list has the column formatted as hh:mm, but the same information in the pivot table comes out in hh:mm:ss format. I re-format it, but everytime I refresh data it reverts back to the hh:mm:ss format. How can I stop this change happening. I have even ticked the preserve formatting box in options, but it still does it. I am using Excel 2000 with XP. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table formatting
You need to set the formats using the pivot table functionality (field
settings of the pivot field). Not the normal Excel way (Format / Cells). Choose the number option and format accordingly. I also believe the field selection needs to be "enabled" (see pivot table toolbar) for it to work. Hope this is a start. Bill Horton "thunderbirds" wrote: I have created a pivot table which includes a column showing times. The data list has the column formatted as hh:mm, but the same information in the pivot table comes out in hh:mm:ss format. I re-format it, but everytime I refresh data it reverts back to the hh:mm:ss format. How can I stop this change happening. I have even ticked the preserve formatting box in options, but it still does it. I am using Excel 2000 with XP. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table - New Data | Excel Discussion (Misc queries) | |||
Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |