Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I recently updated to Excel 2007 and can't figure out how to perform a
function I used to on my old version of excel. I have a column of dates: 01/02/2009 01/13/2009 02/07/2009 02/19/2009 I want to sort by month, not by dates within a month. I used to format the cell to show the date as "January" or "February." Then I would use the Data-Text to Columns function and click column type "Text." That would change the contents of the cell to January, February, etc. This allowed me to easily subtotal by month. How can I do this in Excel 2007? Thank you, Heather |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying Excel 2007 chart to Word 2007 - only half of it shows | Excel Discussion (Misc queries) | |||
Excel 2007 files not showing on screen when opened in Excel 2007 | Setting up and Configuration of Excel | |||
Conflict in excel 2007 with Outlook 2007 attachment excel | Excel Discussion (Misc queries) | |||
Labels: Unable to import all records Excel 2007 to Word 2007 Mailm | Excel Discussion (Misc queries) | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) |