Can't Convert Date to Text?

[Al Franz]

Having a hard time converting DATES to TEXT so I can sort the Dates by
Month. Look at the attached spreadsheet.

http://netmation.com/excelsrt.xls

Col A = Date
Col B = TEXT(DATE)
Col C = Paste Special Value of Col B.

Why won't Col B or C sort by Month, they all sort by year?? Using Excel
2007.

 

[muddan madhu]

col B use this =TEXT(A2,"mmm")

Col C =TEXT(A2,"yyyy")

now you can sort by month or year

 

[Pete_UK]

In separate columns you could have:

B1: =MONTH(A1)
C1: =YEAR(A1)

these will give you numbers as the result, which can then be sorted as
you wish (include column A in the sort range).

Hope this helps.

Pete

 

[Don Guillett]

Using the autofilter you have set up, filter on column B>custom>begins with
07