Thread: sort dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pammy Pammy is offline
external usenet poster
 
Posts: 96
Default sort dates

I have dates formatted as 02/01/06, but when I sort in ascending order,
nothing seems to sort correct, there is a mixture of 06, 00, 05. I looked
for any character such as a space in front or a dot instead of a / to see if
this was the problem. Any thoughts?