sorting in Excel?

Question

In MS-Excel, When i am sorting the dates in a column of format dd/mm/yyyy, say example 10/06/2007 and 02/10/2007, the sorted column shows 02/10/2007 in first row.
Please suggest me, how can i solve this problem.

The format is English (UK).

While sorting, it has to check year first then month and then Day. But its happening vice versa. Its a list of records.

Answer 1

Even though you have shown the date format as dd/mm/yyyy, I think you haven't changed it in the number format. The default format is mm/dd/yyyy..



Now I think you have to change the positions of the month & the day since excel considers your date as the month and your month as the date. If you have a long list of dates, do the following..



Say your first date is in D1. Type in E1 the following formula



=DATE (YEAR (D1),DAY (D1),MONTH (D1))



Copy that formula down and change the format to dd/mm/yyyy if you want.. Then you can do the sorting.......

Answer 2

I agree. Dates are merely numbers formatted from January 1, 1900. Therefore, if they are true numbers/dates they would sort correctly, no matter what format you put them in.

Answer 3

Strange - Mine sorts fine. Are you sure you are sorting a date column and not text column? Because a text column would sort as you described.



wdw

Answer 4

interior the type show screen there is an decision on the backside for Header row or no header row. make helpful header row is chosen and it is going to bypass away the header row and type something.

Answer 5

problematic point. search over google. that could actually help!

Answer 6

there is a button on standard toolbars "sort ascending" beside it is "sort descending" could you please try the second?



does it work?