How to set the MS Excel 2007 date column in descending

Hello experts,

I have a report generated in MS 2007, with 7 columns and 1000 rows, of which two columns are in dd/mm/yyyy format, with years 2007/09/10/11.

I would like to report to display in ascending, starting from dates 2007 to 2011.

Is this possible if so how to go about it?

Please advise.

Thanks and Regards.
 Screenshot
goprasadAsked:
Who is Participating?
 
Sandesh1983Connect With a Mentor Commented:
select any one cell of the column that you want to sort and then go to Data >> Sort and then click on AtoZ
0
 
Sandesh1983Commented:
here is the screen shot for your reference..
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
goprasadAuthor Commented:
I want the corresponding columns data also to sort according to the dates. I just don;t want to end up sorting just the dates column.
0
 
Sandesh1983Commented:
this will also consider all the corresponding columns.  
0
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
If the dates are true dates rather than text representations of dates, the data sort as proposed above will work fine.

If the dates are text format then it will sort them as if it is a string of text so all the days beginning 01 will come first, then 02 etc etc.

If this is the case, the text can be converted into a number fairly easily in a number of ways.

Formula:
=VALUE(G2)  assuming dates in column G

Text to Column function:
Highlight the range of dates to be converted, only one column at a time.
From the Data menu select Text to Columns
Step 1  Select Delimited  Click Next
Step 2  Deselect all delimiters, click next
Step 3  In the Column Data format box select Date and use the dropdown to select the date format of the text, click Finish

Now format the cells to the date format you require using the usual cell formatting routine and sort as per above suggestions.

Cheers
Rob H
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.