Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format a Grouped Date in a Pivot Table
Using Excel 2007, I created a pivot table and where I grouped a date
field by Days and set the Number of Days as 7 (essentially grouping it by weeks). Here is an example of what shows up in the table: 12/2/2006 - 12/8/2006 Is there anyway to format this grouped label so that it appears like the following: 12/02/06 - 12/08/06 Changing the field settings/number format does not seem to work. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format a Grouped Date in a Pivot Table
The date should use the short date format from your regional settings,
in the Control Panel. If you change that to MM/dd/yy you'd get the grouping label that you want. lsantos13 wrote: Using Excel 2007, I created a pivot table and where I grouped a date field by Days and set the Number of Days as 7 (essentially grouping it by weeks). Here is an example of what shows up in the table: 12/2/2006 - 12/8/2006 Is there anyway to format this grouped label so that it appears like the following: 12/02/06 - 12/08/06 Changing the field settings/number format does not seem to work. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format a Grouped Date in a Pivot Table
On Mar 9, 3:02 pm, Debra Dalgleish wrote:
The date should use the short date format from your regional settings, in the Control Panel. If you change that to MM/dd/yy you'd get the grouping label that you want. lsantos13 wrote: Using Excel 2007, I created a pivot table and where I grouped a date field by Days and set the Number of Days as 7 (essentially grouping it by weeks). Here is an example of what shows up in the table: 12/2/2006 - 12/8/2006 Is there anyway to format this grouped label so that it appears like the following: 12/02/06 - 12/08/06 Changing the field settings/number format does not seem to work. -- Debra Dalgleish Contextureshttp://www.contextures.com/tiptech.html Perfect - that was it exactly. Thank you very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Date in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table grouped results | Excel Worksheet Functions | |||
how to change date formating-grouped by month in pivot table | Excel Discussion (Misc queries) | |||
elucidating grouped headings in pivot table | Excel Discussion (Misc queries) | |||
Pivot table-show all grouped items | Excel Discussion (Misc queries) |