It's a simple query, but I really need it answered as I'm about to lose a LOAD of data!! Please help!!
I have a worksheet that has a date column in it along with entries for that day. The thing is it won't sort correctly and I dont know how to fix it. When I sort the date column it does this:
30/4/02
30/4/02
29/4/02
29/4/02
28/4/02
3/5/02
3/5/02
2/5/02
2/5/02
1/5/02
This is wrong. What I need it to do is sort so that the most recent date is near the top, like this:
3/5/02
3/5/02
2/5/02
1/5/02
30/4/02
29/4/02
29/4/02
and so on...
it seems to be sorting it by the day number and not by the whole date and I dont know how to stop it! Can anyone help me, I am really in trouble here!!
Janie
I have a worksheet that has a date column in it along with entries for that day. The thing is it won't sort correctly and I dont know how to fix it. When I sort the date column it does this:
30/4/02
30/4/02
29/4/02
29/4/02
28/4/02
3/5/02
3/5/02
2/5/02
2/5/02
1/5/02
This is wrong. What I need it to do is sort so that the most recent date is near the top, like this:
3/5/02
3/5/02
2/5/02
1/5/02
30/4/02
29/4/02
29/4/02
and so on...
it seems to be sorting it by the day number and not by the whole date and I dont know how to stop it! Can anyone help me, I am really in trouble here!!
Janie