How to make excel format Day,Month,Date,Year- this order

Discussion in 'Software Q&A' started by keves2002, Oct 16, 2009.

Thread Status:
Not open for further replies.
  1. keves2002

    keves2002 Guest

    Dear All,

    I have a spreadsheet with a single columns of dates I would like to sort by the order as they appear in the calder with out loosing the current format of Day, Month, Date den year.
    eg :-

    (Below is the data i have )
    Friday, October 06, 2006
    Friday, October 13, 2006
    Friday, October 20, 2006
    Friday, October 27, 2006
    Monday, October 02, 2006
    Monday, October 09, 2006
    Monday, October 16, 2006
    Monday, October 23, 2006
    Monday, October 30, 2006
    Thursday, October 05, 2006
    Thursday, October 12, 2006
    Thursday, October 19, 2006
    Thursday, October 26, 2006
    Tuesday, October 03, 2006
    Tuesday, October 10, 2006
    Tuesday, October 17, 2006
    Tuesday, October 24, 2006
    Tuesday, October 31, 2006
    Wednesday, October 04, 2006
    Wednesday, October 11, 2006
    Wednesday, October 18, 2006
    Wednesday, October 25, 2006




    (Expecting to be like this)
    Monday, October 02, 2006
    Tuesday, October 03, 2006
    Wednesday, October 04, 2006
    Thursday, October 05, 2006
    Friday, October 06, 2006
    Monday, October 09, 2006
    Tuesday, October 10, 2006
    Wednesday, October 11, 2006
    Thursday, October 12, 2006
    Friday, October 13, 2006
    Monday, October 16, 2006
    Tuesday, October 17, 2006
    Wednesday, October 18, 2006
    Thursday, October 19, 2006
    Friday, October 20, 2006
    Monday, October 23, 2006
    Tuesday, October 24, 2006
    Wednesday, October 25, 2006
    Thursday, October 26, 2006
    Friday, October 27, 2006
    Monday, October 30, 2006
    Tuesday, October 31, 2006

    Please advise if you have a solution. Thank you!
     
    Last edited by a moderator: Oct 16, 2009
  2. FilledVoid

    FilledVoid Who stole my Alpaca!

    Joined:
    Jan 4, 2005
    Messages:
    1,821
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    Kerala
    OK here goes.

    1. Did you actually select the dates (Highlight all of them) and then just click the sort button on your toolbar?

    2. Try selecting the cells and then go to Format and select Dates and then try sorting it again.

    3. If you find that they don't sort the way you want it usually its because your dates aren't actually stored as dates but its stored as text. In such a case you could try this. First save your data. Then go to an empty cell and type the number 1 . Select that cell and then go to Edit > Copy . Select all the cells with the dates in it. Go to Edit > Paste Special > Multiply. This should change the dates to numbers if they follow the standard date format. Format the numbers to whatever format you want using the Format option and now try sorting it like usual.

    PS: I use Excel 2000 since I really doubt I need anything beyond its capabilities . There might be easier solutions but these are the oens that come to my mind.

    Cheers.
     
  3. OP
    OP
    keves2002

    keves2002 Guest

    Thanks Mr.Void, I am bit tied up with a presentation for a client, i will get back to u as soon as i tried the solution recommended

    TIA
    -keves-
     
Thread Status:
Not open for further replies.

Share This Page