Thread: Excel 2007
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HeatherJ HeatherJ is offline
external usenet poster
 
Posts: 24
Default Excel 2007

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