Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Assume that I have the following information:
Date 03/01/08 03/02/08 03/03/08 03/04/08 03/05/08 and so on... If I were to use the Date in a column for a pivot table I would get five separte columns. What I would like to get just one column that would read March 2008. Is there a way to format the information in the Date column so that it would be read as March 2008 for a pivot table or is there a formula that I can use that would do the same thing? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing footers on all worksheets without changing print set up | Excel Discussion (Misc queries) | |||
Changing n/a to zero | Excel Discussion (Misc queries) | |||
Changing the TAB key | Excel Discussion (Misc queries) | |||
changing a cell to changing the link | Excel Worksheet Functions | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) |