sorting does not depend upon format,.
suppose your data is from A2 down(A1 having column heading)
in B2 copy this formula
and copy this down the B column(type some thing e.g. month in B1)
now highlight both columns and sort according to B
after sorting if you want you cant delete column B