Can't Convert Date to Text?

  • Thread starter Thread starter Al Franz
  • Start date Start date
A

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.
 
col B use this =TEXT(A2,"mmm")

Col C =TEXT(A2,"yyyy")

now you can sort by month or year
 
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
 
Back
Top