sort function for dates does not sort properly in Office 2007 Exc.

[Rosalie]

I cannot get dates to sort properly & numbers are sorting incorrectly eg 11
sorts before 2 (descending order)..Any way to show numbers as 02, 03 etc? I
have Office 2007 program.

 

[Pete_UK]

If 11 sorts before 2 then you have text values that just look like
numbers. I suspect the same is true for your dates if they do not sort
correctly - they are text values which look like dates, rather than
proper Excel-recognised dates.

You can get 2 to look like 02 by using Format | Cells, but this will
only work if you have true numbers. Instead, you could stick to text
values and have a formula like this:

=IF(LEN(A1)=1,"0"&A1,A1)

and copy down. This assumes the you only have "numbers" up to 2
digits, otherwise you would want 002, 012, 112 etc.

Hope this helps.

Pete