Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help....Date Format issue
Hi,
I produce pivot tables that detail time worked by month but I receive the information in the following date format: 01/10/08, 02/10/08 etc. I want to be able to format the date so that the name of the month appears (prior to running the pivot) i.e OCT. I have tried using custom formatting i.e MMM which is OK but when I run the pivot the individual days still appear in separate columns and not just the total for OCT in one column. Please can anyone help. Thanks Sandy -- SandyW |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help....Date Format issue
You'll need another column in your data (creating another field for your
PivotTable) Assuming dates are in column A =MONTH(A2) copy down, format as "mmm". Remember to give this column a label (Month) You now use the Month field in your Pivot Table. NOTE: Based on what you said, no distinction is made between years. All of 1/08 data would be grouped with 1/09 data. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "SandyW" wrote: Hi, I produce pivot tables that detail time worked by month but I receive the information in the following date format: 01/10/08, 02/10/08 etc. I want to be able to format the date so that the name of the month appears (prior to running the pivot) i.e OCT. I have tried using custom formatting i.e MMM which is OK but when I run the pivot the individual days still appear in separate columns and not just the total for OCT in one column. Please can anyone help. Thanks Sandy -- SandyW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel date format issue | Excel Discussion (Misc queries) | |||
date format issue | Excel Discussion (Misc queries) | |||
Date format issue | New Users to Excel | |||
DATE FORMAT issue | Excel Worksheet Functions | |||
Date format issue | Excel Worksheet Functions |